Is it possible to start a transaction inside another transaction ?
Should I specify a particular isolation level ?
Any ideas or tricks are welcome.
ThanXYes you can have nested transactions.
When I have complex work to perform or cascading delets, I set IMPLICIT_TRANSACTIONS to on and then manage commits/rollbacks myself. Otherwise I stick to AUTOCOMMIT.
I would encourage you to look up "transactions, described" in Books On Line.
Showing posts with label transactions. Show all posts
Showing posts with label transactions. Show all posts
Friday, March 30, 2012
Subscribe to:
Posts (Atom)