Author Topic: What are the different types of lock modes in SQL Server?  (Read 209 times)

Offline Samson

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What are the different types of lock modes in SQL Server?
« on: October 24, 2014, 11:39:06 AM »
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.
« Last Edit: December 09, 2017, 06:07:48 PM by Sofyene »



Offline Nicholas

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Lock modes in SQL Server?
« Reply #1 on: December 09, 2017, 06:09:28 PM »
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)


 

Sitemap 1 2 3 4 5 6 7 8 9