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

Published: 18 September 2022
on channel: Right to Learn @BK
20,520
399

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


Watch video ACID properties in SQL server | Atomicity, Consistency, Isolation and Durability | SQL interview Q&A online without registration, duration hours minute second in high quality. This video was added by user Right to Learn @BK 18 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 20,520 once and liked it 399 people.