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.
|
No comments:
Post a Comment