At isolation in select / readtext statement

at isolation {integer_expression | level_expression }


Isolation level		Remarks
0	read uncommitted	dirty reads
1	read committed	default isolation level
2	repeatable read
3	serializable	holdlock / avoid phantoms ANSI default isolation level

Sets the transaction isolation level for one query.

Examples

select PartCode from T_Part at isolation read uncommitted

declare @ptr varbinary(16)

select @ptr = TextPtr( Info ) from T_Part where PartCode = 'UTP CABLE'

readtext T_Part.Info @ptr 1024 2048 at isolation 2