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)
abitguru
Ten Centuries
Points: 1170
More actions
March 25, 2013 at 6:09 am
#1600254
Thanks McSQL
Will read the thread!
I try (with updlock) but dont work in my case, cause transaction 1 has a page lock that prevents transation 2 to takes a row