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 vote313 views1 answer
How to make case insensitive in sql
SQL
1 vote283 views1 answer
Oracle list constraints
SQL
0 vote292 views2 answers
Mysql regexp match word
SQL
4 votes293 views2 answers
How to insert ip address in mysql using php
SQL
1 vote308 views1 answer
Postgres power
SQL
0 vote324 views1 answer
Get primary key of table
SQL
11 votes312 views3 answers
How to get last row of table in sql
SQL
0 vote293 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote298 views1 answer
Sql get month from date
SQL
0 vote294 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL