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 |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2007-05-02 : 02:46:48
|
| Hi, Please tell me, what is difference between rollback in Stored procedure and rollback in Trigger.SQLTeam |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-02 : 03:00:25
|
| There is no difference in Rollback in SP and trigger. The difference lies in how transaction is initiated in both. In SP, you have to explicitly create transaction by specifying BEGIN TRANSACTION, whereas statements in trigger are part of the same transaction as the statement that fired the trigger.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Rollback