In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?

by

You’re probably looking forwith (updlock, holdlock). This will make a select grab an exclusive lock, which is required for updates, instead of a shared lock. The holdlock hint tells SQL Server to keep the lock until the transaction ends.

FROM TABLE_ITEM with (updlock, holdlock)

More Related Contents:

  1. Confused about UPDLOCK, HOLDLOCK
  2. Updating image in VB and SQL Server not working [closed]
  3. Only inserting a row if it’s not already there
  4. The order of a SQL Select statement without Order By clause
  5. Storing a file in a database as opposed to the file system?
  6. Preferred Method of Storing Passwords In Database
  7. Oracle: is there a tool to trace queries, like Profiler for sql server? [closed]
  8. What columns generally make good indexes?
  9. How to determine total number of open/active connections in ms sql server 2005
  10. Getting execute permission to xp_cmdshell
  11. TSQL: Create a view that accesses multiple databases
  12. What resources exist for Database performance-tuning? [closed]
  13. Forcing a query timeout in SQL Server
  14. SQL Server, the misleading XLOCK & optimizations
  15. Deferrable Constraints in SQL Server
  16. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  17. How to create a yes/no boolean field in SQL server?
  18. Best way to store time (hh:mm) in a database
  19. How can I run just the statement my cursor is on in SQL Server Management Studio?
  20. Executing set of SQL queries using batch file?
  21. Database design: Calculating the Account Balance
  22. Using SQL Server as a DB queue with multiple clients
  23. Date range overlapping check constraint
  24. What are the advantages of VistaDB
  25. How do I list all the columns in a table?
  26. Difference between database and schema
  27. Generate table relationship diagram from existing schema (SQL Server) [closed]
  28. Calculate Time Difference Between Two Rows
  29. EF Core takes a lot of time, sometimes, to perform SELECT query
  30. Tool for Scripting Table Data

Leave a Comment