November 14, 2005 at 2:27 am
hi, my problem is that i have 2 tables say:
table1:
section varchar(10) primary key
table2:
office varchar(20)
table1 contents are
john
kim
table2 contents are
mega-john
small-john
lil-kim
jumbo-kim
etc.
Whenever i update values in table1, i want to update values in table2. i dont wanna use foreign keys.
Please help
Thanks in advance
Chhana.
November 14, 2005 at 6:14 am
Before declarative constraints (eg FK's) came to SQL Server, triggers was used to enforce referential integrity. If that is your purpose, then start by looking at CREATE TRIGGER' in BOL (Books On Line) You'll find a lot of good reading on the subject there to get you started.
/Kenneth
November 15, 2005 at 10:54 am
I don't understand why you need to do this. Aren't you using some sort of primary keys in the main table? That way the name could change without having to change the keys in the other tables.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply