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 vote359 views1 answer
Sql create and grant user access to database
SQL
0 vote341 views2 answers
Faster mysql imports
SQL
17 votes379 views3 answers
Postgresql list users
SQL
0 vote317 views2 answers
Return the number of records in a single table mysql
SQL
6 votes343 views2 answers
What is non relational database
SQL
0 vote389 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote318 views1 answer
Oracle merge insert if not exists
SQL
24 votes320 views2 answers
Alter table delete column
SQL
0 vote359 views1 answer
Distance calculator from lat long sql query
SQL
15 votes340 views2 answers
Select where duplicate mysql
SQL