What is a transaction and what are ACID properties?

Posted by

To view Verified answers click on the button below.

A transaction is a logical unit of work in which, all the steps must be performed or none.
ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a
transaction. For more information and explanation of these properties, see SQL Server
books online or any RDBMS fundamentals text book.