Can you have a nested transaction?

Question Posted / swapna

4 Answers
10306 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can you have a nested transaction?..

Answer / brahma

Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1

Is This Answer Correct ?

3 Yes

0 No

Can you have a nested transaction?..

Answer / visala

yes, we can have nested transactions. to know the nest
level use @@trancount

Is This Answer Correct ?

3 Yes

1 No

Can you have a nested transaction?..

Answer / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Is This Answer Correct ?

1 Yes

1 No

Can you have a nested transaction?..

Answer / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

Is This Answer Correct ?

1 Yes

2 No

Post New Answer