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

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)

Related Contents:

  1. Confused about UPDLOCK, HOLDLOCK
  2. Optimistic vs. Pessimistic locking
  3. Only inserting a row if it’s not already there
  4. The order of a SQL Select statement without Order By clause
  5. Query to list number of records in each table in a database
  6. Storing a file in a database as opposed to the file system?
  7. Multiple Indexes vs Multi-Column Indexes
  8. Preferred Method of Storing Passwords In Database
  9. Using a sort order column in a database table
  10. Create a view with ORDER BY clause
  11. Oracle: is there a tool to trace queries, like Profiler for sql server? [closed]
  12. What columns generally make good indexes?
  13. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  14. How to do version control for SQL Server database?
  15. How to create a yes/no boolean field in SQL server?
  16. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  17. How to determine total number of open/active connections in ms sql server 2005
  18. What is the Oracle equivalent of SQL Server’s IsNull() function?
  19. Best way to store time (hh:mm) in a database
  20. How to check if a database exists in SQL Server?
  21. How to migrate a PostgreSQL database into a SQLServer one?
  22. What resources exist for Database performance-tuning? [closed]
  23. How can I run just the statement my cursor is on in SQL Server Management Studio?
  24. What is the point of “Initial Catalog” in a SQL Server connection string?
  25. Executing set of SQL queries using batch file?
  26. SQL Server, the misleading XLOCK & optimizations
  27. Tool for Scripting Table Data
  28. Database design: Calculating the Account Balance
  29. Database that can handle >500 millions rows
  30. Using SQL Server as a DB queue with multiple clients
  31. Check if table exists in SQL Server
  32. What is the significance of 1/1/1753 in SQL Server?
  33. Which are more performant, CTE or temporary tables?
  34. SQL – How to store and navigate hierarchies?
  35. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  36. How can I force entity framework to insert identity columns?
  37. Hidden Features of SQL Server
  38. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  39. Do I really need to use “SET XACT_ABORT ON”?
  40. Export table from database to csv file
  41. Is it possible to force row level locking in SQL Server?
  42. How to display table data more clearly in oracle sqlplus
  43. Creating audit triggers in SQL Server
  44. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  45. What are named pipes?
  46. Why the SQL Server ignore the empty space at the end automatically?
  47. How can I know when SQL Full Text Index Population is finished?
  48. Installing Oracle 32-bit Client on Windows Server Already Running 64-bit Oracle Database Server
  49. SELECT INTO a table variable in T-SQL
  50. Removing the remembered login and password list in SQL Server Management Studio

Leave a Comment