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 |
|
laailalalaa
Yak Posting Veteran
57 Posts |
 Posted - 2010-05-10 : 03:49:08
|
| if i have two insert triggers on the same table, do they get executed the same order they were created?thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-10 : 04:19:16
|
| Not necessarily.You can define a first and a last to fire, if you have more than 3 triggers of the same type (why?), all but the first and last may fire in any order.Why 2 triggers? Why not one trigger that does both things?--Gail ShawSQL Server MVP |
 |
|
|
laailalalaa
Yak Posting Veteran
57 Posts |
Posted - 2010-05-10 : 11:27:59
|
| just curiositythanks GilaMonster |
|
|
|
|
|
|
multiple triggers, same table, same triggering op