Transactions and Locking

Watch the first few minutes on us! If you'd like to watch the entire video and hundreds more like it, download code samples, access offline videos and skills assessments, and use the discussion forums, log in or purchase a subscription.


Mark Dunn


Up to this point in the course, you've been working as if you were the only user in the database. In the real world, you will encounter multiple users working simultaneously, often attempting to make changes to the same data at the same time. In this session, you'll learn to handle conflicts by wrapping action statements inside a transaction and controlling how aggressively SQL Server goes about locking data.

Table of Contents

{{toc.Position}} {{toc.Text}}

Related Links

  • {{link.LinkText}} (requires a paid subscription)


This course is part of the following series: