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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2010-12-06 : 07:03:06
|
| Dear Experts,We are having three triggers on a single table.1 One is for insert in which the record is updated.2 Second is after update in which some TSQL code has been written.3 Third is after insert in which some TSQL code is written.The problem is when ever we inserts data inside the table the "for insert" trigger is fired which in turn fires the update trigger.We want to first fire the third insert trigger before the "for insert" trigger.please help. thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-06 : 07:10:03
|
| have alook at sp_settriggerordernote - for and after mean the same thing.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Control execution of triggers