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 vote183 views1 answer
Oracle drop chain step
SQL
0 vote140 views1 answer
Formatting code with SQL Developer
SQL
2 votes149 views1 answer
Date conversion in mysql column
SQL
0 vote153 views1 answer
Select top 3 sql
SQL
0 vote149 views1 answer
Kill thread
SQL
0 vote143 views1 answer
Create new schema mysql
SQL
0 vote252 views1 answer
How to use select union and loop
SQL
1 vote171 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote140 views1 answer
Max length found in mysql
SQL
12 votes148 views1 answer
Psql drop column
SQL