Home Forums SQL Server 2008 SQL Server 2008 - General ROWLOCK RE: ROWLOCK
ESAT ERKEC
SSCertifiable
Points: 5661
More actions
March 19, 2013 at 1:27 am
#1598309
In my application i set the transaction first
BEGIN TRAN
UPDATE TESTROWLOCK SET ID=ID WHERE ID=2
SELECT ID FROM TESTROWLOCK WHERE ID=2
i want to change
this
SELECT ID FROM TESTROWLOCK (hint row base lock ?) WHERE ID=2