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 vote222 views1 answer
Microsoft sql server python connection
SQL
0 vote200 views1 answer
Sql query for select from specific columns in a table
SQL
3 votes229 views1 answer
Start mysql server by terminal in linux
SQL
0 vote212 views1 answer
Mysql Error Code: 1005
SQL
1 vote218 views1 answer
How to between in sql
SQL
1 vote181 views1 answer
Metada in sql
SQL
1 vote215 views1 answer
Oracle duration between timestamps
SQL
0 vote210 views1 answer
Narural join
SQL
7 votes246 views2 answers
Phpmyadmin change password
SQL
1 vote196 views1 answer
Select random sample sql
SQL