Standard T-SQL transaction template
Created 21 January 2005 00:00
  BEGIN TRANSACTION

  -- do updates etc 

  IF @@ERROR <> 0 
    ROLLBACK TRANSACTION
  ELSE
    COMMIT TRANSACTION