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
Post a Comment