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 vote110 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote151 views1 answer
Influxdb list all tags for a measurement
SQL
50 votes176 views6 answers
Sql count duplicate rows
SQL
-1 vote113 views4 answers
Postgres between dates
SQL
1 vote164 views2 answers
Copy table in sql
SQL
4 votes110 views1 answer
Mac install mysql
SQL
2 votes127 views2 answers
Mysql find max value row
SQL
0 vote112 views3 answers
Sql parenthetical expression examples
SQL
-1 vote105 views1 answer
Sql getdate date only
SQL
1 vote120 views1 answer
How to run parallel queries in sql server with entity framework
SQL