Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
TRANSACTION « Transaction « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Transaction
TRANSACTION
23.1.TRANSACTION
23.1.1.
A transaction is bound by the ACID test. ACID stands for Atomicity, Consistency, Isolation (or Independence), and Durability:
23.1.2.
Explicit Transaction Commands
23.1.3.
Using Transactions
23.1.4.
BEGIN TRANSACTION
23.1.5.
Using Explicit Transactions
23.1.6.
Forcing an exclusive table lock.
23.1.7.
Transaction spread across batches:
23.1.8.
Exception before transaction committing
23.1.9.
statements coded as a transaction
23.1.10.
A script with nested transactions
23.1.11.
One batch that contains two transactions
23.1.12.
What happens with stored proc transactions and exceptions?
23.1.13.
Declare variable in a transaction
23.1.14.
Inserting a Row into MyTable and Rolling Back the Transaction