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 vote288 views1 answer
Mssql now diff 90 day
SQL
1 vote269 views10 answers
Stack overflow
SQL
0 vote324 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote297 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote294 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote316 views1 answer
Select distinct after join
SQL
4 votes280 views2 answers
Select first and last row mysql
SQL
2 votes272 views1 answer
How to select first row of database sql
SQL
2 votes265 views2 answers
Function in sql
SQL
0 vote285 views1 answer
Select amount weeks between two dates mysql
SQL