MS SQL Server
Lock hints in SQL FROM clause
- All the ANSI isolation levels, plus …
- UPDLOCK - use update locks instead of read locks
- READPAST - ignore locked rows (if running read committed)
- PAGLOCK - use page lock when the system would otherwise use a table lock
- TABLOCK - shared table lock till end of command or transaction
- TABLOCKX - exclusive table lock till end of command or transaction