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