Answer Posted / suraj
like this
select *
from dbo.Address
with (nolock)
-- above query doesn't hold lock while retrieving data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different methods available under sqlcommand class to access the data?
Mention the differences between local and global temporary tables.
What is a derived table?
Write a SQL command to insert and update only a particular field?
What is “asynchronous” communication in sql server service broker?
What are the tool windows in sql server management studio? : sql server management studio
How is table type constraint applied to a table?
What is a database table?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Is it true, that there is no difference between a rule and a check constraint?
What is a partitioned view?
What is set nocount on and what is set nocount off?
What is row_number()?
What are “lost updates”?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.