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 most transaction then what would happened?
Lets you have below query, what would be the output of following query?
Ans: All three record would be saved
Lets you have below query, what would be the output of following query?
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