how to implement locking in sql server

Question Posted / ravi148

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
locks

Is This Answer Correct ?

5 Yes

8 No

More SQL Server Interview Questions

Find top Nth employee from each department in terms of salary?

What is normalization and denormalization in sql server?

How reterive duplicate value in SQL?

Write down the syntax and an example for create, rename and delete index?

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

How do you trace the traffic hitting a sql server?

What is the difference between having clause and where clause in sql server?

How to enforce security in sql server? : sql server security

What are the different Authentication modes in SQL Server and how can you change authentication mode?

What is database replication? What are the different types of replication you can set up in sql server?

How to view existing indexes on an given table using sys.indexes?

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

For more SQL Server Interview Questions Click Here