SQL Triggers... a newbie howto question

[nickmollberg]

I need to create a trigger that does the following:
When a user inserts or modifies a record in tableA, if a certain column 'ColStatus' is equal to 'Complete' then I need to change a value in tableB to reflect this.

Can anybody point me to a good syntax example, or a howto for how I should go about this?

 

[tlbroadbent]

SQL Books online has some good trigger examples.

Assuming some relationship exists between tableA and tableB this code should get you started.

Create Trigger trgUpdate on TableA
For Insert, Update
As

Update TableB Set col1 = 'value'
Where Exists
 (Select * From inserted
  Where inserted.relatedcol = tableb.relatedcol
    And inserted.colstatus = 'complete')

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm