SQL Transactions

« Previous Tutorial Next Tutorial »

In SQL, a Transaction is a unit of work that is performed against a database

Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program

A Transaction is the propagation of one or more changes to the database. For example, if you are creating/updating/deleting a record from the table, then you are performing transaction on the table. It is important to control the transactions to ensure data integrity and to handle database errors

Practically, you will club many SQL queries into a group and you will execute all of them together as a part of a transaction

Properties of Transactions

Transactions have the following four standard properties, usually referred to by the acronym ACID listed below:

SQL Transaction Control

There are the following SQL commands which can be used to control the transactions:

SQL Transactional control commands are only used with the DML commands UPDATE, INSERT, and DELETE only

SQL Online Test

« Previous Tutorial Next Tutorial »

© Copyright 2021. All Rights Reserved.