ACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&A

A transaction in SQL Server is a group of SQL statements that are treated as a single unit and they are executed by applying the principle “do everything or do nothing” The acronym ACID was created by Andreas Reuter and Theo Harder in the year 1983, however, Jim Gray had already defined these properties in the late 1970’s. Most of the popular databases such as SQL Server, Oracle, MySQL, Postgre SQL follows the ACID properties by default. A - Atomicity C - Consistency I - Isolation D - Durability