How we can implement Row lock explicitly in SQL Server?

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

Using "With (ROWLOCK)" we can implement Row Lock Explicitly. with this we prevent the command to lock the whole page or table.

Thamks & Regards
Lakhan Pal Garg

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Saranpselvam on: 4/7/2014 | Points: 10
use like this

select studentid from studentifo with(rowlock)

Login to post response