Home > DeveloperSection > Forums > SQL Server 2000 constraint involving column on different table
john rob

Total Post:108

Posted on    May-04-2013 2:13 AM

 MSSQL Server MSSQL Server 

 1 Reply(s)
 852  View(s)
Rate this:
Hi Expert!

I would like a constraint on a SQL Server 2000 table column that is sort of a combination of a foreign key and a check constraint. The value of my column must exist

in the other table, but I am only concerned with values in the other table where one of its columns equal a specified value. The simplified tables are:

part_number  varchar(30)
quantity     int

part_number  varchar(30)
type         char(1)
So I want to ensure the part_number exists in inventory_master, but only if the type is 'C'. Is this possible? Thanks.

Thanks in advance!


Total Post:604

Posted on    May-04-2013 9:06 AM

Hi John!

You could use an INSTEAD OF INSERT trigger to emulate that behaviour.

Check value existence when an insert is about to occur.

Don't want to miss updates? Please click the below button!

Follow MindStick