Chapter 12: Managing SQL Server Transactions and Locks

About This Chapter

SELECT or UPDATE statements. Locks prevent conflicts so that users cannot read or modify data that other users are in the process of changing. Transactions use locking to prevent users from modifying data affected by transactions that have not been completed. This chapter introduces you to the fundamentals of transactions and locks and then describes how transactions and locks are used to process data modifications.