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 vote374 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote355 views1 answer
Multiple count in sql
SQL
28 votes361 views6 answers
Mysql change user password
SQL
0 vote347 views2 answers
Check mysql timezone
SQL
-1 vote340 views1 answer
How to open blade file from blade in laravel
SQL
0 vote380 views1 answer
How to move a columns location in mysql
SQL
2 votes359 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote348 views1 answer
Postgresql select fast check no rows
SQL
0 vote353 views1 answer
Sql select most frequent value in column
SQL
0 vote341 views1 answer
Mysql query single row
SQL