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

13 votes169 views4 answers
Mysql get last row
SQL
5 votes196 views1 answer
Oracle nls instance
SQL
0 vote193 views1 answer
Allow null in psql
SQL
9 votes168 views2 answers
Default number in sql
SQL
0 vote180 views1 answer
Raiserror with nowait
SQL
0 vote176 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote180 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
2 votes177 views2 answers
Run mysql command from bash
SQL
1 vote202 views1 answer
Sql server loop over query
SQL
4 votes201 views3 answers
Sqlite show columns
SQL