• 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

    BEGIN TRAN

    SELECT ID FROM TESTROWLOCK (hint row base lock ?) WHERE ID=2