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 vote162 views2 answers
Import .sql into postgres db command
SQL
51 votes413 views6 answers
Installing mysql on ubuntu
SQL
0 vote158 views1 answer
Oracle list datafiles
SQL
4 votes157 views2 answers
Oracle sql group by date year
SQL
2 votes157 views1 answer
Oracle to_char number format percentage
SQL
0 vote164 views2 answers
Reseed sql identity
SQL
39 votes255 views5 answers
Sql drop column
SQL
2 votes142 views2 answers
Change varchar length mysql
SQL
0 vote145 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote133 views1 answer
How to check oracle index table
SQL