Tagged Questions
1
vote
2answers
391 views
How to lock a Row while I'm using it
I want to be able to Lock a row, select it, increment its value, and then release the lock. (without lockin the other rows, so that other connections can work with the rest of the table)
I've found ...
1
vote
2answers
1k views
Deadlock on Insert/Update
Using SQL Server 2008 R2:
I'm currently attempting to track down the cause of a deadlock issue we have. Not sure where to turn. Here's the setup.
TABLE Scores:
id INT IDENTITY(1,1),
first_name ...