Outer Transaction is Rollbacked, then what would happned, try to answer: COMMIT/TRAN

Question:  Lets suppose that you have three level nested transaction, and you commit two inner transactions and you roll-backed outer most transaction then what would happened?

Lets you have below query, what would be the output of following query?
How many record would be inserted?
Ans: nothing, If you rollback outer transaction then everything will be roll-backed.


  1. Very informative post is this. I like it well and hoping you will be here with more.



Contact Form