BEGIN TRANSACTION T1

   Update and Verify Data here

if (Data Verified)
   COMMIT TRANSACTION T1
else
   ROLLBACK TRANSACTION T1

BEGIN TRANSACTION T1

  BEGIN TRANSACTION T2

   Update and Verify Data here
  if (Data Verified)
     COMMIT TRANSACTION T2
  else
     ROLLBACK TRANSACTION T2



if (Data Verified)
   COMMIT TRANSACTION T1
else
   ROLLBACK TRANSACTION T1