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 vote259 views1 answer
Add alternate add column sql
SQL
1 vote270 views2 answers
Mysql remove first and last character from string
SQL
1 vote277 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote260 views1 answer
Search db for table name
SQL
1 vote278 views1 answer
How to change owner in postgres
SQL
0 vote271 views1 answer
Postgresql import a database of gzip
SQL
0 vote319 views2 answers
Sql unique
SQL
1 vote284 views3 answers
Alter schema sql server
SQL
0 vote270 views1 answer
How to find sql server name
SQL
2 votes272 views4 answers
List databases in sql server
SQL