Finishing the Transaction
If the transaction goes successfully then the COMMIT command will commit the changes to the database.
However, if an error occurs the ROLLBACK command can be used to restore the database to its state prior to the transaction.