MSSQL Tutorial Transaction 22 codes

  1. Home
  2. MSSQL Tutorial
  3. Transaction
1 A script that performs a test before committing the transaction
2 A script with nested transactions
3 A transaction is bound by the ACID test ACID stands for Atomicity, Consistency, Isolation (or Independence), and Durability.tx
4 A transaction with two save points
5 BEGIN TRANSACTION
6 Declare variable in a transaction
7 Effect of exceptions on transactions
8 Exception before transaction committing
9 Explicit Transaction Commands
10 Forcing an exclusive table lock
11 Inserting a Row into MyTable and Rolling Back the Transaction
12 One batch that contains two transactions
13 Returning Number of Open Transactions
14 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
15 Statements coded as a transaction
16 Syntax for SET TRANSACTION ISOLATION LEVEL
17 Testing transaction isolation levels
18 The savepoint has meaning only inside a nested transaction
19 Transaction spread across batches
20 Using Explicit Transactions
21 Using Transactions
22 What happens with stored proc transactions and exceptions