Topmusicanswers
- When should I use Updlock?
- What is Rowlock Updlock?
- What is an update lock?
- Does SQL Server lock table on update?
When should I use Updlock?
UPDLOCK uses an update lock when reading a table instead of a shared lock, and keeps the lock until the end of the statement or transaction.
What is Rowlock Updlock?
ROWLOCK tells SQL Server to only use row-level locks. UPDLOCK is only for a row of records in the table to lock to prevent other operations from updating the row's data.
What is an update lock?
Update lock (U) is used to avoid deadlocks. Unlike the Exclusive lock, the Update lock places a Shared lock on a resource that already has another shared lock on it. Also, it is possible to place a shared lock on a resource that has an update lock.
Does SQL Server lock table on update?
Typically no, but it depends (most often used answer for SQL Server!) SQL Server will have to lock the data involved in a transaction in some way. It has to lock the data in the table itself, and the data any affected indexes, while you perform a modification.
