OK SO we have two sessions.
First one starts a transaction
begin tran insert into users values('bla','bla')
Then
Second One: Select * from users...
The second session hangs till the transaction is committed or rollbacked.
Is there a way that, the select statement returns data the way it was before
the begining of the transaction.
First one starts a transaction
begin tran insert into users values('bla','bla')
Then
Second One: Select * from users...
The second session hangs till the transaction is committed or rollbacked.
Is there a way that, the select statement returns data the way it was before
the begining of the transaction.