Side Gadgets

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

4 comments
Share
Labels

Comments

  1. ninatorres7 February 2017 at 21:07

    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.

    ReplyDelete
    Replies
    1. Vikas8 February 2017 at 00:22

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

      Delete
    2. Vikas8 February 2017 at 00:25

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

      Delete
  2. Anonymous4 May 2018 at 04:32

    Please explain the logic

    ReplyDelete

Contact Form

Send