Home Forums SQL Server 2008 SQL Server 2008 - General Lock only one row in update (lock a row) RE: Lock only one row in update (lock a row)
McSQL
SSCarpal Tunnel
Points: 4936
More actions
March 25, 2013 at 5:59 am
#1600250
You can use the WITH UPDLOCK clause in your update query.
There's a good thread on it here;
http://stackoverflow.com/questions/1921091/thread-safe-sql-transaction-how-to-lock-a-specific-row-during-a-transaction