Let's assume the following case.
There is a
id | name ----------------- 1 | Mateus
A "User A" executes the following statement without committing the transaction:
update students set name = 'Gustavo' where id = 1
Then a "User B" executes the following query:
select * from students with (nolock) where id = 1
User B will get the name
Gustavo, that's the expected behavior. The DB will return the uncommitted value because of the
Is there a way to get the old name,
Mateus (the previously committed value), even when there's an uncommitted transaction?