Holdlock / NoHoldLock /Shared Table hint

These table hints affect the isolation level:

holdlock = isolation level 3

noholdlock = isolation level 1

shared does not apply to an isolation level, but specifies that shared locks should be used instead of update locks.

Example

select @ptr = TextPtr( Info ) from T_Part holdlock

where PartCode = 'UTP CABLE'