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 vote178 views1 answer
How to print sql query
SQL
8 votes189 views1 answer
Show mysql user table
SQL
0 vote175 views1 answer
Delete insert record in sql server
SQL
0 vote171 views1 answer
Select all same column value in sql
SQL
4 votes185 views2 answers
Sql offset
SQL
2 votes196 views2 answers
Create table mysql integer NOT null
SQL
0 vote209 views1 answer
Sql date with year
SQL
3 votes185 views1 answer
Oracle list privileges
SQL
5 votes182 views2 answers
Add column postgres with default value
SQL
7 votes180 views1 answer
Minecraft forge server host
SQL