Advanced T-SQL (part 2): Transaction

In this part, transaction will be discussed in detail.

What is transaction?

A transaction is a logical unit of work that contains one or more SQL statements. A transaction is an atomic unit. The effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

Properties of transaction:

Follow the ACID principle, which are:

1. Atomicity: Transactions are…