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 vote267 views1 answer
Raven ql select count
SQL
0 vote274 views1 answer
Sql check if column exists
SQL
0 vote259 views1 answer
Get cpu details sql
SQL
3 votes248 views3 answers
Docker create postgresql database
SQL
0 vote278 views1 answer
Copy row from db to db mysql
SQL
1 vote258 views1 answer
Oracle explain plan
SQL
0 vote261 views1 answer
How to select even id in sql
SQL
0 vote285 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote249 views1 answer
Renommer table sql
SQL
6 votes262 views1 answer
Check Table Exists
SQL