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 vote203 views1 answer
Get first 3 letter of department name in sql
SQL
6 votes320 views1 answer
Check Table Exists
SQL
3 votes166 views2 answers
Coalesce mysql
SQL
1 vote211 views2 answers
Postgresql check privileges on schema
SQL
8 votes291 views1 answer
Insert a select statement into a table
SQL
1 vote182 views1 answer
Mysqli connect
SQL
1 vote154 views1 answer
Oracle character set
SQL
0 vote193 views1 answer
Sql find leading space
SQL
39 votes306 views5 answers
Sql drop column
SQL
37 votes247 views6 answers
Mysql update
SQL