Groups | Blog | Home
all groups > sql server new users > january 2005 >

sql server new users : Triggered Event Timing?


Jim Shaw
1/25/2005 10:06:49 AM
BlankA SQL Server book suggested that I should think of a trigger as being
like an Access "before update" event process.
I need a triggered procedure to run "after" an add, delete or update.

Can such a thing be done?

Thanks
Jim

Cristian Lefter
1/25/2005 5:56:12 PM
You are referring to "AFTER" triggers. Please refer to books online "CREATE
TRIGGER"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp.

Cristian Lefter, SQL Server MVP

[quoted text, click to view]

AddThis Social Bookmark Button