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 vote233 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote213 views2 answers
Remove space in mysql
SQL
2 votes202 views1 answer
Mysql time ago difference
SQL
1 vote197 views1 answer
Select not matching data from two tables
SQL
3 votes203 views5 answers
Mysql get last inserted id
SQL
3 votes193 views1 answer
Oracle undo tablespace list by user
SQL
0 vote198 views1 answer
Sql get month from date
SQL
2 votes191 views2 answers
Postgres set user as superuser
SQL
36 votes228 views3 answers
Add column in mysq
SQL
1 vote214 views1 answer
ORA-01950
SQL