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

3 votes166 views2 answers
Sql add year to date
SQL
0 vote188 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote287 views3 answers
Uninstall postgresql mac
SQL
0 vote165 views1 answer
Ignore case in string sql
SQL
0 vote218 views1 answer
Mysql remove last character
SQL
0 vote172 views1 answer
Closure in sql
SQL
10 votes171 views2 answers
Sql rtrim
SQL
0 vote161 views1 answer
Oracle last character of string
SQL
0 vote184 views1 answer
Stored function in sql
SQL
1 vote168 views1 answer
Sometimes i cant edit sql developer
SQL