how to implement locking in sql server
Answers were Sorted based on User's Feedback
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 |
Answer / rama krishna
no need to impliment locks sql server automatically holds
locks
| Is This Answer Correct ? | 5 Yes | 8 No |
What is the sql case statement used for?
What is named calculation? : sql server analysis services, ssas
What is the purpose of forms?
How do I view a procedure in sql server?
How to perform key word search in tables?
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
Which are the third-party tools used in sql server and why would you use them?
What is sql server english query?
How send email from database?.
3 Answers CarrizalSoft Technologies, Merrill Lynch,
What is difference between index seek vs. Index scan?
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
Differentiate between ms sql server reporting services vs crystal reports?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)