Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Nesting Transactions
If a Trans Proc is issued in program 1 with BEGIN TRAN and updates several tables, then a function is called that contains it's own Trans Proc that updates several tables and is successful and commits with END TRAN and then returns control to program 1 which for some reason has a reason to issue ROLLBACK, are the updated tables in the functions TRANS PROC rolled back also ?
Thanks CB !!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement