Interested to Buy Any Domain ? << Click Here >> for more details...
how to implement locking in sql server
- 3 Answers
- 8688 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 |
what are the main differences between ms access and sqlserver
What is the difference between Triggers and Stored Procedure?
What are rows and columns?
When would you use a before or after trigger?
Difference between connected and disconnected database in .net with sql server?
when would you go for denormalization? : Sql server database administration
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are the lambda triggers?
What is 1nf 2nf and 3nf?
Find top Nth employee from each department in terms of salary?
What is indexed views? plz explain with example?
What is the difference between value type and reference type?
-
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)
