how to implement locking in sql server

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


Please Help Members By Posting Answers For Below Questions

Explain how to maintain a fill factor in existing indexes?

506


What is rtm version in sql server?

502


What are the types of ssrs?

108


How can a user-defined datatype be created?

519


What are tables in sql server?

507






Why and when do stored procedure recompile?

527


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1379


What are alternate keys?

544


Explain the database you used in your final year project?

514


Do you know sql server 2008 backup compression?

547


What are two difference between sql azure and azure tables?

135


What is an expensive query?

514


How many types of schemas are there?

509


What is BCNF? How is it better than 2NF & 3NF?

574


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

540