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

Post a Comment

* Please Don't Spam Here. All the Comments are Reviewed by Admin.
  1. 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.

    1. Ninatorres,
      Thanks for your kind comment... keep learning...

    2. If you have such tricky questions then plz share... This questions was asked during HCL and UHG interview, in Gurgaon.