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 vote115 views1 answer
Materialized view redshift
SQL
18 votes126 views3 answers
Mysql current date
SQL
4 votes144 views2 answers
SELECT table_name FROM user_tables;
SQL
8 votes135 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote123 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
4 votes125 views1 answer
Add constraint fk
SQL
0 vote177 views1 answer
Sql alter table add column if exists
SQL
1 vote145 views1 answer
Sample clause in sql
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote157 views1 answer
Insert column after column mysql
SQL