what range confine nested sell sql server?


consider following sql:




begin tran
set transaction confine turn review committed

insert bands
( name )
select 'depeche mode'
union
select 'arcade fire'

-- i've indented middle transaction clearer.

start tran
set transaction confine turn review uncommitted

name *
bands

commit

-- confine turn right here?

update bands
set name = 'modest mouse'
where name = 'oddest house'

commit


in sum, start transaction set the confine turn read committed. following futile sql start another, nested transaction. transaction change confine turn read uncommitted. following dedicate transaction relapse other.



now, speculation after middle commit, confine turn advantage read committed. correct?



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members