Conversions in MS SQL Server
Update-lock prevents lock conversion deadlock.
Conflicts with other update and write locks, but not with read locks.
Only on pages and rows (not tables)
You get an update lock by using the UPDLOCK hint in the FROM clause
Select Foo.A
From Foo (UPDLOCK)
Where Foo.B = 7
Previous slide
Next slide
Back to first slide
View graphic version