CAD/MCSE/MCDBA Self-Paced Training Kit [Electronic resources]: Microsoft SQL Server 2000 Database Design and Implementation, Second Edition (Exam 70-229)

Microsoft Corporation

نسخه متنی -صفحه : 223/ 87
نمايش فراداده

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.