Tag Info

New answers tagged


Is it ok to use the word "commit" for nested transactions? I think so. The syntax is still COMMIT TRANSACTION or COMMIT WORK. How 'commits' of nested transactions are handled is implementation-dependent, but it seems common to treat them as a no-op. Handling nested rollbacks is much more interesting. In SQL Server at least, it requires marking a ...


I don't think there is a problem using the word commit and personally I don't see a better wording for the concept. Most database systems do not support nested transactions, the only one I could find is BerkelyDB. In their documentation on nested transactions they are using commit as the term. Committing a nested transaction has no effect on the state ...

Top 50 recent answers are included