Outer Transaction is Committed but nested trans rollbacked, then what would happned, try to answer: COMMIT/TRAN SQL SERVER
Question: Lets suppose that you have three level nested transaction, and you Rollbacked two inner transactions and you Committed outer mo...

https://www.interviewquestionspdf.com/2016/01/outer-transaction-is-committed-but.html
It’s actually a great and useful piece of info.I’m happy that you just shared this useful info with us. Please stay us informed like this. Thank you for sharing.
ReplyDeleteNinatorres,
DeleteThanks for your kind comment... keep learning...
If you have such tricky questions then plz share... This questions was asked during HCL and UHG interview, in Gurgaon.
DeletePlease explain the logic
ReplyDelete