Summary of Locking Hints Used
- ROWLOCK: Locks a single row, avoiding locking an entire page or table.
- UPDLOCK: Acquires an update lock on a row or table, preventing modifications by others until the lock is released.
- XLOCK: Places an exclusive lock on the data, preventing both reads and writes by other transactions.
- HOLDLOCK: Equivalent to SERIALIZABLE isolation level, keeping the lock until the transaction is complete.