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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2004-11-27 : 15:04:21
|
| hello,I would like to know how many transactions you can have in a trigger and how many if statements could be nested in a trigger ?e.g.if @@error = 0 -- transaction 1begin--statements go hereendelse goto option1-- transaction 2if @@error <> '0'begin--statements go hereendelse goto option2option1:--statmentsoption2:insert into error_table (msg)values (@@error)Would a trigger like this be ok ?Afrika |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2004-11-27 : 15:21:44
|
| Cant see any reason why it wouldnt work.You might have to watch performance if the table is hit a lot. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-27 : 16:22:40
|
| And don't cross post==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2004-11-28 : 07:43:46
|
| thanks a lot, I didnt say it didnt work, am just asking if its an ok practicesince its my first time trying such a thing outthanks |
|
|
|
slserra
Starting Member
19 Posts |
Posted - 2005-11-15 : 16:58:00
|
| Just testing the 'subscribe to a topic' email. |
|
|
|
|
|
|
How many transaction could you have in a trigger?