Can we use shared lock with Update Statement?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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

Bookmark It

< Previous : What is the name of the System table from where we ...

Next > : What is the name of the table from which we can ge ...

Comments or Responses

More Interview Questions by Lakhangarg

What is the name of the table from which we can get the Locking inform ...
How we can implement Row lock explicitly in SQL Server?
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 ...

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 ...