like this select * from dbo.Address with (nolock) -- above query

how to implement locking in sql server

Question Posted / suraj

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

Please Help Members By Posting Answers For Below Questions

What are .mdf files?

691

What are locks in sql?

707

What is exporting and importing utility?

774

What is an entity-relationship diagram (erd)?

811

What is openxml in sql server?

878

Define msdb database?

785

How to receive returning result from a query?

748

How to set database to be single_user in ms sql server?

761

Can you explain different types of locks in sql server?

709

Name few of the dcl commands in sql?

716

What is the use of custom fields in report?

762

Explain what are the restrictions that views have to follow? : SQL Server Architecture

801

What is the difference between a unique key and primary key?

681

Can we insert data if clustered index is disabled?

678

Which table keeps the locking information?

695