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 votes306 views3 answers
Into in sql
SQL
0 vote317 views1 answer
Sql replace id with name from another table
SQL
0 vote310 views1 answer
Online sql testing tool
SQL
2 votes320 views1 answer
Compare date in sql
SQL
0 vote337 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote322 views1 answer
Ubuntu connect to mssql database
SQL
0 vote343 views1 answer
Mysql last friday of current month
SQL
0 vote311 views2 answers
Getting customers with no orders sql
SQL
7 votes324 views4 answers
Mysql delete older duplicates
SQL
0 vote298 views1 answer
Dns slave zone convert
SQL