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
Sql find record cannot cast date
SQL
1 vote155 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote134 views1 answer
Create table Statement Syntax in SQL Server
SQL
9 votes151 views5 answers
Laravel to sql
SQL
1 vote165 views1 answer
Postgresql pass array in function
SQL
14 votes151 views3 answers
Oracle sql limit results
SQL
0 vote139 views1 answer
Oracle drop type
SQL
1 vote159 views1 answer
How do you use sql in you company
SQL
0 vote130 views1 answer
Check duplicate values plsql
SQL
0 vote134 views1 answer
How to use group_concat in sql server
SQL