p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or rollback inner transaction separately as the outer transaction will override with its commit/rollback command. If this is true, why do we need to use nested transactions or in which scenario nested transactions can be used?

let me know if my question is not clear


_________
Andrew

 
create table #TransTest (i integer)

begin tran OuterTran
  insert into #TransTest (i) values (1)

  save tran InnerTran
  insert into #TransTest (i) values (2)
  rollback tran InnerTran

commit tran OuterTran

select * from #TransTest

drop table #TransTest

p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or rollback inner transaction separately as the outer transaction will override with its commit/rollback command. If this is true, why do we need to use nested transactions or in which scenario nested transactions can be used?

let me know if my question is not clear


_________
Andrew