Sql server set complex constraints

CREATE FUNCTION dbo.fnIsAddressOwner (
  @CustomerId int,
  @AddressId int
)
RETURNS tinyint
AS
BEGIN
  DECLARE @Result tinyint
  IF EXISTS(SELECT * FROM CustomerAddresses WHERE CustomerId=@CustomerId and AddressId=@AddressId)
    SET @Result= 1
  ELSE 
    SET @Result= 0
  RETURN @Result
END


CREATE TABLE Customers (
  CustomerId int,
  PreferredAddressId int,
  CONSTRAINT ckPreferredAddressId CHECK (
    dbo.fnIsAddressOwner(CustomerId, PreferredAddressId) = 1)
  )
)

Source: stackoverflow.com

Similar codes

0 vote308 views1 answer
Select from 3 tables one is empty
SQL
1 vote322 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote319 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
1 vote320 views1 answer
Install postgresql on raspberry pi
SQL
16 votes360 views6 answers
Mysql find duplicates in same table
SQL
0 vote327 views1 answer
Create database store
SQL
0 vote334 views1 answer
Sql count matching group by
SQL
0 vote343 views1 answer
Insert set mysql
SQL
0 vote327 views1 answer
Search column name sql
SQL
0 vote318 views3 answers
Group_concat sql server
SQL