ID Number: Q62859
1.10 1.11 4.20
OS/2
Summary:
The following information describes what happens when a SELECT is done
with HOLDLOCK.
If you do a SELECT with HOLDLOCK within a transaction and get no hits,
either an index page or the whole table will be locked until commit.
If the optimizer used a unique index to process the select, the index
page where the missing item belongs will be locked. If the optimizer
did not use a unique index to process the query, the entire table will
be locked.
Additional reference words: 1.10 1.11 4.20 Transact-SQL