Summary

Now that you have completed this module, you understand what a transaction is, and how it compares to SQL batches. You have learned how to construct a transaction, and where to place the BEGIN TRANSACTION and COMMIT or ROLLBACK TRANSACTION keywords when using structured error handling. Now that you have completed this module, you can:

• Describe transactions.
• Compare transactions and batches.
• Create and manage transactions.
• Handle errors in transactions.
• Describe concurrency.

Learn more

For more information about the topics discussed in this module, see:

• Transactions (Transact-SQL) - SQL Server
• BEGIN TRANSACTION (Transact-SQL) - SQL Server
• COMMIT TRANSACTION (Transact-SQL) - SQL Server
• ROLLBACK TRANSACTION (Transact-SQL) - SQL Server
• XACT_STATE (Transact-SQL) - SQL Server
• Transaction Isolation Levels