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

7 votes377 views1 answer
Mysql remote connection command line
SQL
0 vote339 views1 answer
Sql gap missing values
SQL
1 vote335 views1 answer
Select from one table where not on the other
SQL
0 vote372 views1 answer
Mysql best varchar length size
SQL
1 vote351 views1 answer
Mysql event last execution
SQL
1 vote300 views1 answer
Insert into sql
SQL
15 votes341 views3 answers
Create table with primary key auto increment in sql
SQL
11 votes351 views1 answer
Oracle view ddl
SQL
1 vote358 views3 answers
Mysql parse int
SQL
1 vote354 views1 answer
Alter add syntax
SQL