Hi my current understanding of nested transactions in TSQL is that if you have multiple transactions (several transactions nested inside of one "outer" transaction), all of the tranasactions must be committed (with the "outer" transaction being the last one) for any changes to the database to be made. If the number of commits are less than the number of open transactions then no changes related to any of the transactions are made. Is this a correct overview of how nested transactions work?
2 Answers
Related