how to implement locking in sql server
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rama krishna
no need to impliment locks sql server automatically holds
locks
Is This Answer Correct ? | 5 Yes | 8 No |
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What does select 1 mean?
What are the different types of replication you can set up in sql server?
What is sub query and its properties?
What is the difference between a function and a stored procedure?
What is the main difference between ‘between’ and ‘in’ condition operators?
How many databases Microsoft SQL server provides?
What is SQL Profiler and the use of it?
Explain the usage of floor function in sql server.
What is a function? Give some example?
how to select 5 to 7 rows from a table, which contains 10 rows?
What is a trigger and types of a trigger?