changing/setting isolation level at query-level

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 189
we can set isolation level at query-level or database-level or instance-level in SQL Server..

Sometimes we might have been asking to change the isolation at query-level..

To do so, the below is the code snippet used...


SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
GO

Comments or Responses

Login to post response