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

5 votes181 views3 answers
Sql max value in column
SQL
1 vote195 views1 answer
Vagrant mysql downgrade version
SQL
0 vote166 views1 answer
Price-colour
SQL
26 votes126 views10 answers
Insert in to table sql
SQL
1 vote162 views1 answer
Not exists mysql
SQL
0 vote181 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote224 views1 answer
Sql query for login with email or username
SQL
46 votes178 views4 answers
Create column sql
SQL
0 vote169 views1 answer
If column value is null then in mysql
SQL
0 vote178 views1 answer
<sql:datasource var="Snapsho"
SQL