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 vote140 views1 answer
Can we rollback in sql
SQL
0 vote146 views1 answer
Oracle array
SQL
7 votes113 views1 answer
Mysql load data infile csv
SQL
0 vote98 views1 answer
Bigquery information_schema schema all columns
SQL
9 votes159 views3 answers
Import DB through mysql console
SQL
0 vote151 views1 answer
Sql use with to get value counts and percentages
SQL
8 votes157 views1 answer
Oracle search stored procedures for text
SQL
0 vote160 views1 answer
Full outer join in mariadb mysql
SQL
1 vote205 views1 answer
SQL server query column yes or no
SQL
0 vote126 views1 answer
Prepared statement mysql java delete selected rows
SQL