The SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED is at different part of the "BEGIN". Is the below two query behave the same?
Will the views, viewOne and viewTwo, inherit the dirty read? Or the view needs to have an explicit "NOLOCK"
Query 1
set transaction isolation level read uncommitted
begin
select col1 from viewOne
select * from viewTwo
select * from table1
end
Query 2
begin
set transaction isolation level read uncommitted
select col1 from viewOne
select * from viewTwo
select * from table1
end