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 votes97 views1 answer
Postgresql where current year
SQL
0 vote199 views1 answer
How to rename a database in tsql
SQL
0 vote132 views1 answer
Report in database
SQL
0 vote136 views1 answer
Postgresql delete multiple rows
SQL
0 vote155 views1 answer
Original Query
SQL
0 vote131 views1 answer
SQL server select to get sum of hours
SQL
8 votes136 views2 answers
Replace string value in sql
SQL
6 votes131 views1 answer
Wordpress change user password sql
SQL
0 vote138 views1 answer
How to increase the width of the screen in oracle
SQL
3 votes151 views2 answers
Oracle apex view logs
SQL