« previous next »
Pages: [1]   Go Down

Author Topic: What are the different types of lock modes in SQL Server?  (Read 169 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 »
Logged


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)
Logged
Pages: [1]   Go Up
« previous next »
 

Sitemap 1 2 3 4 5 6 7 8 9