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

1 vote206 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote254 views1 answer
Sqlalchemy on delete set null
SQL
1 vote228 views1 answer
Sql server set variable if exists
SQL
10 votes207 views1 answer
User_dependencies
SQL
4 votes199 views1 answer
Create table if not exist in sqlite
SQL
0 vote206 views1 answer
Mysql exception output
SQL
0 vote207 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote218 views1 answer
How to display value of variable in mysql
SQL
0 vote219 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote227 views1 answer
Oracle string length
SQL