how to implement locking in sql server
- 3 Answers
- 7801 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
Do you know what is a linked server in sql server?
What is a with(nolock)?
How do you drop an index?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
What do you mean by COLLATION?
whate is advantages of sql server 2000
what is a live lock? : Sql server database administration
What is DCL?
What are defaults? Is there a column to which a default can't be bound?
How many index keys possible for a table
Tell me the difference between clustered and non-clustered index?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
