Locks in SQL Server

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  March 12, 2010 at 4:33 am

  #217812

  hi,

  I've basic doubt about locking "select Statement will lock the table", i'm thinking that select statement will hold shared lock.

  thanks,

  🙂

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  March 12, 2010 at 6:23 am

  #1132623

  Yes, a SELECT statement places a shared lock on the table, not an exclusive lock.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning