trigger to update one table after another update

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 to update one table after another update

Author

Topic

aymanPadma
Starting Member

1 Post

Posted - 2006-10-11 : 13:54:12

Hello All, I need to create a trigger that updates a field of one table AFTER an update in another table (where an order is voided) occures by using the customer id of that particular update. Can someone please help me with this? Much appreciated..

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-12 : 00:39:06

You need to create AFTER UPDATE trigger on the table:

CREATE TRIGGER T1
ON TBL2
AFTER UPDATE
AS
   UPDATE TBL1
   SET FLD = ...
END

Read about CREATE TRIGGER in books online.

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources