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 vote252 views1 answer
Mysql could not fetch tables
SQL
0 vote174 views1 answer
Pgadmin see indexes
SQL
8 votes197 views2 answers
Grant all privileges database postgres to user
SQL
1 vote272 views4 answers
Alter schema sql
SQL
1 vote181 views2 answers
Extract weekday from date in sql
SQL
6 votes191 views3 answers
Sql select last id
SQL
0 vote228 views1 answer
Original Query
SQL
0 vote172 views1 answer
Mysql add to value
SQL
0 vote223 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
6 votes267 views2 answers
Non relational database
SQL