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 difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
write the query for taking database restore in sql?
Which institute is best for SQL Server 2005 Training?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is table valued function and scalar valued functions?
What is data source in connection string?
What is table constraint?
What is sql injection? How to protect against sql injection attack?
how we can store the value like that 001,003,023 etc in sql server 2005
What are different types of schemas?
What is the Main Difference between ACCESS and SQL SERVER?
Explain the basic concepts of SQL server architecture?
2 Answers College School Exams Tests,
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)