In this query :
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Select * from table1
Go
Select * from table2
Go
Does it mean that the READ UNCOMMITTED would gonna work only on the Select * from table1 becuase of the Go ?
And why this don't work?
declare @var varchar(20)
set @var = 'fdsdsf'
select 'var'
go
select @var
the go must eliminate in order for this to work
GO is a batch separator used by SSMS or SQLCMD. It is not part of the SQL standard and should not have an effect on ISOLATION LEVEL.
As per MSDN, "Only one of the isolation level options can be set at a time, and it remains set for that connection until it is explicitly changed." In your case, therefore, the READ UNCOMMITTED will work for both queries.
Go- This is used for execution and is used to Signals the end of a batch of Transact-SQL statements to the SQL Server utilities.. Nothing with Transaction or isolation level.
Read Uncommited is work for both query because it work for single transaction till the transaction open.(it is maintained by sqlserver, so don't worry)
Read Uncommited :- It is is SQL Server's default transaction isolation level.
