O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Characteristics of Transactions (ACID)

A transaction is a sequence of operations executed as a single logical operation, which must expose the ACID (Atomicity, Consistency, Isolation, and Durability) properties. These are as follows:

  • Atomicity—The transaction must be executed as an atomic unit of work, which means that it either completes all of its data modifications or none at all.

  • Consistency—The data is consistent before the transaction begins, and the data is consistent after the transaction finishes. To maintain consistency, all integrity checks, constraints, rules, and triggers must be applied to the data during the transaction. A transaction can affect some internal SQL Server data structures, such as allocation maps and indexes, and SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required