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

2 votes126 views1 answer
Sql server find columns list in tables
SQL
8 votes127 views1 answer
Oracle search text in all packages
SQL
2 votes141 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote126 views1 answer
Normalization in database
SQL
2 votes110 views1 answer
Scaffold npgsql net core
SQL
0 vote108 views10 answers
Sql statement checker corrector
SQL
0 vote117 views1 answer
Oracle character index
SQL
-1 vote73 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote78 views3 answers
Mysql calculate age from date of birth
SQL
1 vote120 views1 answer
Where to locate set password for mysql
SQL