learn

BEGIN TRANSACTION (Transact-SQL)

Applies to: SQL Server 2008 (10.0.x) and later versions, Azure SQL Database, Azure SQL Managed Instance, SQL database in Microsoft Fabric. If WITH MARK is used, a transaction name must be specified.
learn

COMMIT TRANSACTION (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Marks the end of a successful implicit or ...
GitHub

rollback-transaction-transact-sql.md

This statement rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction. You use ROLLBACK TRANSACTION to erase all data ...
GitHub

how-to-write-sql-server-unit-test-that-runs-in-single-transaction-scope.md

You can modify unit tests to run within the scope of a single transaction. If you take this approach, you can roll back any changes that the test enacted after the test ends. The following procedures ...
habr

[Перевод] Обработка ошибок и транзакций в SQL Server. Часть 1. Обработка ошибок – быстрый старт

Поведение SQL Server по умолчанию в той ситуации, когда не используется TRY-CATCH, заключается в том, что некоторые ошибки прерывают выполнение и откатывают любые открытые транзакции, в то время как с ...