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

2 votes367 views2 answers
How to rename column name in sql server using query
SQL
0 vote395 views1 answer
Select top values sql
SQL
0 vote357 views1 answer
Horizontal join sqlite
SQL
7 votes387 views5 answers
Oracle alter table
SQL
0 vote352 views1 answer
Set column width in sqlplus
SQL
3 votes354 views1 answer
Oracle revoke
SQL
0 vote374 views1 answer
Oracle 11g forget password
SQL
0 vote341 views1 answer
Mysql error codeigniter
SQL
0 vote400 views1 answer
Contraint default SQL
SQL
0 vote351 views1 answer
Oracle last character of string
SQL