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.
Lets you have below query, what would be the output of following query?
Ans: nothing, If you rollback outer transaction then everything will be roll-backed.
Very informative post is this. I like it well and hoping you will be here with more.
ReplyDelete