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

1 vote153 views3 answers
Sql procedure
SQL
0 vote128 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote174 views1 answer
Ms sql print more than 1 variable
SQL
0 vote128 views2 answers
Start mysql server using docker
SQL
1 vote129 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote130 views1 answer
Concatenate columns in table
SQL
1 vote143 views2 answers
Foreign key set 0
SQL
0 vote140 views1 answer
Firebird where
SQL
1 vote146 views1 answer
Sqlite update from another table
SQL
3 votes121 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL