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 is the correct order of the logical query processing phases?

917

What do you mean by tablesample?

1063

Can we call stored procedure in trigger?

931

What is key set driven?

929

What is the purpose of sql profiler in sql server?

995

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

930

What are the difference between “where” and “having” clause in sql server?

1048

What is the difference between dropping a database and taking a database offline?

1148

Can a synonym name of a table be used instead of a table name in a select statement?

1008

Can you edit the .rdl code associated with a linked report?

160

What is an index in sql?

988

What sql server means?

944

Explain transaction isolation levels in sql server?

1088

Describe how to use the linked server?

1123

How to create a view with data from multiple tables?

996