Yes I executed the second  query as below in another SSMS session, and the query result that I got was inconsistent as it displays all records.

SET TRANSACTION ISOLATION LEVEL REPEATABLE...