Friday, June 28, 2019

ROLLBACK; as a standalone command in T-SQL

SET IMPLICIT_TRANSACTIONS ON turns on implicit transactions and these can wrap two back to back inserts for example. ROLLBACK; can rollback a transaction or what you might think of as an implicit transaction. See: this

No comments:

Post a Comment