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 vote340 views1 answer
Const pool = mysql.createpool()
SQL
4 votes350 views3 answers
Check if two date ranges overlap sql server
SQL
9 votes322 views2 answers
Mysql change value
SQL
0 vote327 views1 answer
Where case insensitive like mysql
SQL
0 vote334 views2 answers
Cascade syntax in sql
SQL
10 votes338 views3 answers
How to fetch first 5 characters in sql
SQL
2 votes341 views2 answers
Sql strip non alphanumeric characters
SQL
2 votes351 views1 answer
Find all triggers in database
SQL
5 votes365 views3 answers
Postgres show databases
SQL
2 votes358 views1 answer
Q operator in plsql
SQL