Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

how to implement locking in sql server

Answers were Sorted based on User's Feedback

how to implement locking in sql server..

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

how to implement locking in sql server..

Answer / midhun

By using lock hints and Isolation level

Is This Answer Correct ?    0 Yes 0 No

how to implement locking in sql server..

Answer / rama krishna

no need to impliment locks sql server automatically holds

Is This Answer Correct ?    5 Yes 8 No

Post New Answer

More SQL Server Interview Questions

How can i Relate Tables in SSIS

0 Answers   HCL,

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

i have made a project i n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

What the different components of Replication and what is their use?

0 Answers  

How to attach adventureworkslt physical files to the server?

0 Answers  

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

What is instead of dml trigger?

0 Answers  

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,