Can you have a nested transaction?
Answers were Sorted based on User's Feedback
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 |
Answer / visala
yes, we can have nested transactions. to know the nest
level use @@trancount
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / swapna
Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
What Are Three Rules to UseĀ UNION IN SQL SERVER
Is the order of columns in the set clause important in ms sql server?
Explain what are sparse columns?
How do triggers work?
What is the difference between a primary key and a unique key? Are they the same?
Do you know what is a trace frag? Where do we use it?
Explain what role entity and relationship play in an ER diagram.
What is scan table/view and seek table/view when its occurs? : sql server database administration
What do you mean by an execution plan?
What is scalar user-defined function?
How can you get @@error and @@rowcount at the same time?
What you can do to delete a table without the delete trigger firing?