Can we use shared lock with Update Statement?

 Posted by Lakhangarg on 10/28/2009 | Category: Sql Server Interview questions | Views: 3947

No We can't use the shared lock to Update or modifty data. shared lock is used for select operation.
e.g of shared lock is : WITH (HOLDLOCK)

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response