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 vote101 views1 answer
Mysql drop multiple tables at once
SQL
0 vote121 views1 answer
Select odd records sql
SQL
0 vote93 views1 answer
Count the table indatabase
SQL
3 votes122 views3 answers
Mysql get table size
SQL
0 vote114 views1 answer
Setval postgres example table id
SQL
2 votes99 views1 answer
Sqlite3 show columns name
SQL
1 vote127 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote118 views1 answer
Rermove categories woocommerce sql
SQL
0 vote101 views1 answer
Min mysql
SQL
0 vote114 views1 answer
Mysql foreach insert
SQL