O'Reilly logo

Beginning C# 5.0 Databases, Second Edition by Vidya Vrat Agarwal

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

C H A P T E R  8

Understanding Transactions

For any business, transactions play a key role. They may comprise many individual operations and even other transactions. Transactions are essential for maintaining data integrity both for multiple related operations and when multiple users update the database concurrently.

This chapter will talk about the concepts related to transactions and how transactions can be used in SQL Server 2012.

In this chapter, I’ll cover the following:

  • What is a transaction?
  • When to use transactions
  • Understanding ACID properties
  • Transaction design
  • Transaction state
  • Specifying transaction boundaries
  • T-SQL statements allowed in a transaction
  • Local transactions in SQL Server 2012
  • Distributed transactions in SQL Server ...

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