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 vote198 views1 answer
Sql date between one week
SQL
0 vote192 views1 answer
Sql combine results from two tables
SQL
1 vote213 views1 answer
Add multiple row table pl sql
SQL
1 vote207 views1 answer
Too many connections mysql
SQL
0 vote203 views1 answer
Doesn't have default value mysql
SQL
0 vote243 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote196 views1 answer
To change the database owner in SQL server
SQL
3 votes207 views2 answers
How to delete git repo locally
SQL
1 vote180 views1 answer
Mysql server does not start mac
SQL
0 vote188 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL