Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger Help!

Author  Topic 

D-man
Starting Member

3 Posts

Posted - 2000-09-14 : 11:07:33
I need help with triggers.

I need a trigger on Table1.ColumnB that updates all the records in Table2.ColumnC but only where Table2.ColumnA (the FK of Table1's PK) is equal to the PK record in Table1 that was updated.

Searching through the MS SQL Server reference has done little to help me with the syntax after the CREATE TRIGGER clause.

Any code examples or good references (URLs or books) about this would be greatly appreciated.
   

- Advertisement -