Explicit Transaction Commands : TRANSACTION « Transaction « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transaction
3. TRANSACTION

Command                            Description
BEGIN TRANSACTION                  Sets the starting point of an explicit transaction.
ROLLBACK TRANSACTION               Restores original data modified by a transaction, and brings data back to the state it was in at the start of the transaction. Resources held by the transaction are freed.
COMMIT TRANSACTION                 Ends the transaction if no errors were encountered and makes changes permanent. Resources held by the transaction are freed.
BEGIN DISTRIBUTED TRANSACTION      Allows you to define the beginning of a distributed transaction to be managed by Microsoft Distributed Transaction Coordinator (MS DTC). MS DTC must be running locally and remotely.
SAVE TRANSACTION                   SAVE TRANSACTION issues a savepoint within a transaction, which allows one to define a location to which a transaction can return if part of the transaction is cancelled. A transaction must be rolled back or committed immediately after rolling back to a savepoint.
@@TRANCOUNT                        Returns the number of active transactions for the connection. BEGIN TRANSACTION increments @@TRANCOUNT by 1, and ROLLBACK TRANSACTION and COMMIT TRANSACTION decrements @@TRANCOUNT by 1. ROLLBACK TRANSACTION to a savepoint has no impact.

Quote from:
SQL Server 2005 T-SQL Recipes A Problem-Solution Approach