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 votes298 views3 answers
Oracle tablespace usage
SQL
0 vote295 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
8 votes341 views3 answers
Postgres database sizes
SQL
22 votes323 views4 answers
Mysql date_format
SQL
0 vote314 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote312 views1 answer
Psql attribute cannot login
SQL
0 vote303 views1 answer
Python mysql query to dataframe
SQL
0 vote305 views1 answer
Sql convert datetime to year
SQL
2 votes647 views1 answer
Oracle virtual column
SQL
1 vote303 views1 answer
Mysql select another database
SQL