What are the different types of lock modes in SQL Server?

Started by Lance, October 24, 2014, 11:39:06 AM

Previous topic - Next topic

Samson

Hello, I would like to ask you a big question, I would like to know, what are the different types of lock modes in sql server? Please answer me as soon as possible.

Nicholas

Lock modes specify different kinds of locks. The choice of which lock mode to apply depends on the resource that needs to be locked. The following three lock types are used for row- and page-level locking:

Shared (S)
Exclusive (X)
Update (U)