Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gobikannan Ponmalai TRUNCATE in TRANSACTION RE: TRUNCATE in TRANSACTION
Nils Gustav Stråbø
SSChampion
Points: 11259
More actions
January 4, 2011 at 5:45 am
#1268879
Got it wrong because I misread the UNION for UNION ALL. I focused on the transaction rollback and therefore counted the number rows with 3 in it in the first insert statement.
Good question. A good reminder that assumptions seldom leads to any good!