Use the SET TRANSACTION ISOLATION LEVEL statement to specify the isolation level for the transaction. For more information about isolation levels, see Controlling transaction isolation levels.
The statement SET TRANSACTION ISOLATION is based on ANSI SQL.