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

13 votes223 views2 answers
Oracle inner join
SQL
9 votes348 views2 answers
Current date in postgresql minus 1 day
SQL
3 votes204 views1 answer
Oracle limit user tablespace
SQL
0 vote209 views1 answer
Sql #region
SQL
8 votes201 views2 answers
Safe update mode in mysql
SQL
0 vote271 views1 answer
Sql declare variable single line
SQL
-1 vote193 views1 answer
Condition in orderby mysql
SQL
0 vote244 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote198 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote191 views1 answer
Call procedure in wordpress
SQL