BEGIN TRANSACTION without ROLLBACK TRANSACTION

Take notice of using BEGIN TRANSACTION without ROLLBACK TRANSACTION.

ROLLBACK TRANSACTION rolls back a transaction to the beginning of it, or to a savepoint inside the transaction. You don’t need a ROLLBACK TRANSACTION statement within a transaction, but if there isn’t one, then it may be a sign that error handling has not been refined to production standards.

Available in

SQL Code Guard