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

6 votes153 views1 answer
Postgresql get year
SQL
1 vote133 views2 answers
Postgresql remote connect
SQL
0 vote124 views1 answer
Get current date data in mysql
SQL
0 vote76 views1 answer
Oracle list all stored procedures
SQL
0 vote122 views1 answer
Sql server cannot create database diagram
SQL
0 vote118 views1 answer
Commit transaction sql
SQL
0 vote129 views1 answer
Postgres sequence name
SQL
0 vote131 views1 answer
How to run mysql in git bash
SQL
37 votes304 views3 answers
Sql check duplicate value in column
SQL
0 vote123 views2 answers
Imageview setimageresource null
SQL