How we can implement Row lock explicitly in SQL Server?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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

Bookmark It

< Previous : What is the name of the table from which we can ge ...

Next > : What is the system table that holds the Store Proc ...

Comments or Responses

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

Hi
use like this

select studentid from studentifo with(rowlock)

More Interview Questions by Lakhangarg

What is the system table that holds the Store Procedure Script?
What is the use of Set NOCOUNT ON;?
How We can get the DB name using SQL Command?
How we can Create a .SQL File for the Store Procedure in SQL Server 20 ...
How To Get Description Value for Single Column in Table using SQL Comm ...
How To Get Description Value for all Column in Table using SQL Command ...
How To Delete Description Value for a Column in Table using SQL Comman ...
How To Update Description Value for a Column in Table using SQL Comman ...

Latest Interview Questions

Is it possible to hide or mask the extension with other extension of f ...
Which namespace is used to work with RegularExpression in C#?
You catch an unhandled exception in a Page_Error handler. How can you ...
Is it possible to update a connection string stored in the Web.config ...
What are the four phases of a Web Setup Project deployment?
What launch conditions do Web Setup Projects include by default?
You need to obtain performance information about your Web Application. ...
What is LINQ
More ...