ROWLOCK, XLOCK, HOLDLOCK

Use the combination of three for an exclusive rowlock that is held until the end of the transaction