
-- run these one statement at a time
use adventureworks
go

set transaction isolation level repeatable read
begin tran
select top(10) * from HumanResources.EmployeeAddress a
order by a.EmployeeID

-- dont rollback yet
rollback

sp_lock