6.2. Manage Transactions
A transaction is a statement or set of statements that commit together as a single unit. Much of the work that you will do in a database is transactional. SQL Server provides full support for transactional operations. In this section we will look at how SQL Server Manages transactions and how you can control transaction behavior.
6.2.1. Creating Transactions
SQL Server creates some transactions implicitly. Others you can create explicitly. Either way, they are considered ACID transactions and follow the rules laid out earlier in this chapter. First we will look at how SQL Server manages implicit transactions, and then you will learn how to manage transactional behaviors explicitly.
6.2.1.1. Implicit Transactions
Get SQL Server® 2008 Administration: Instant Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
