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 votes286 views1 answer
Mysql clear screen
SQL
6 votes280 views2 answers
Mysql get yesterday
SQL
10 votes280 views1 answer
Query to find object dependencies in oracle
SQL
10 votes247 views2 answers
Sql where clause multiple values
SQL
2 votes284 views1 answer
Oracle percentage
SQL
0 vote288 views1 answer
Sql server change schema of a table
SQL
0 vote294 views1 answer
Php mysqli install
SQL
0 vote295 views1 answer
Watch mysql command line
SQL
9 votes291 views1 answer
No sql
SQL
18 votes272 views6 answers
Drop table if exists
SQL