How You Can Manage Transactions
A transaction is one or more database statements processed as a single, indivisible unit. A transaction begins with the first database statement executed after the application is started or after a previous commit or rollback statement. By default, the transaction continues until one of the following occurs:
• An explicit commit or rollback statement occurs
• A deadlock or log full error occurs
• The application stops
All locks taken during the transaction are held until the transaction is completed, and any changes made to a database by the transaction are not visible to other users until the transaction is committed.