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.
| Author |
Topic |
|
aprichard
Yak Posting Veteran
62 Posts |
 Posted - 2008-08-12 : 05:13:46
|
| Hi,Whats is differnce between For and After Trigger |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-12 : 05:16:58
|
according to BOL http://msdn.microsoft.com/en-us/library/ms189799(SQL.90).aspxquote:
FOR | AFTER AFTER specifies that the trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint checks also must succeed before this trigger fires. AFTER is the default when FOR is the only keyword specified. AFTER triggers cannot be defined on views.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Definition