Can nested transaction roll backed in stored procedure?

Options
- Yes
- No

CORRECT ANSWER : Yes

Discussion Board
Nested Transaction

Yes, nested transactions are rolled back in stored procedure. If a ROLLBACK WORK or ROLLBACK TRANSACTION statement without a transaction_name parameter is executed at any level of a set of nested transaction, it rolls back all of the nested transactions, including the outermost transaction.

Prajakta Pandit 02-21-2017 07:23 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲