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 vote173 views1 answer
Strat with in sql
SQL
-1 vote221 views1 answer
Create view in mysql workbench
SQL
0 vote189 views1 answer
Porcentaje sql
SQL
5 votes196 views2 answers
Oracle rename table
SQL
1 vote196 views1 answer
Mysql show data from table
SQL
4 votes180 views2 answers
Tsql utf to local time
SQL
0 vote300 views1 answer
Drop check command
SQL
1 vote176 views1 answer
Importance of comment in mysql
SQL
0 vote191 views1 answer
Rename view mysql
SQL
0 vote230 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL