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 is difference between commit and rollback when used in transactions?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How to view existing indexes on an given table using sys.indexes?
What is ssrs?
What is the purpose of linked server configuration in sql server?
List some major differences between triggers and stored procedures?
wat wil hapn if we give the both read and deny read permission to user?
What are cursors in ms sql server?
How do I create a stored procedure in sql server?
Where actually sql azure database is hosted?
What is the difference between Triggers and Stored Procedure?
What is read committed?
What extended events?
How to search for a string in all stored procedure in sql server?
What is difference between view and materialized view?