Tuesday, 26 January 2016

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

Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

0 comments:

Post a Comment