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 vote224 views1 answer
When mysql server would not work in xampp
SQL
0 vote242 views1 answer
Postgres clear table
SQL
1 vote254 views2 answers
This month mysql where
SQL
3 votes229 views1 answer
Select table column in sql
SQL
0 vote224 views1 answer
Update using case in mysql
SQL
1 vote228 views1 answer
Load mysql dumb
SQL
0 vote249 views1 answer
Mariadb set vertical output format
SQL
1 vote224 views1 answer
Base nosql
SQL
1 vote252 views1 answer
Postgresql append array
SQL
0 vote232 views1 answer
Oracle list user locked
SQL