Transactions: Maintaining Data Consistency and Recovery

A transaction groups a set of Transact-SQL statements so that they are treated as a unit. Either all statements in the group are executed or no statements are executed.

For more information about transactions, see the Performance and Tuning Guide.

How transactions work

Transactions and consistency

Transactions and recovery

Using transactions

Allowing data definition commands in transactions

System procedures that are not allowed in transactions

Beginning and committing transactions

Rolling back and saving transactions

Checking the state of transactions

Nested transactions

Example of a transaction

Selecting the transaction mode and isolation level

Choosing a transaction mode

Choosing an isolation level

Compliance with SQL standards

Using the lock table command to improve performance

Using the wait/nowait options of the lock table command

Using transactions in stored procedures and triggers

Errors and transaction rollbacks

Transaction modes and stored procedures

Using cursors in transactions

Issues to consider when using transactions

Backup and recovery of transactions

Join cursor processing and
data modifications


	Expand Search