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 vote185 views1 answer
How to find sql server installation folder
SQL
7 votes178 views1 answer
Forge server hosting
SQL
1 vote182 views1 answer
Sql not equal multiple columns
SQL
1 vote200 views1 answer
Oracle enable job
SQL
0 vote352 views1 answer
Oracle sql alter view add column
SQL
-2 votes245 views1 answer
Trunc in sql
SQL
0 vote181 views1 answer
Mysql select all table that have field names
SQL
0 vote207 views2 answers
List all constraints in postgres
SQL
0 vote189 views1 answer
Sql create table with datetime automatically
SQL
5 votes194 views3 answers
Oracle first day of last year
SQL