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