SQL Server - Commit a transaction
SQL Server - Commit a transaction
Confirms every operation performed inside a SQL Server transaction begun with SQL Server: Begin transaction. After the commit, every change is permanently written to the database.
Options
Connection
Reference to the SQL Server: Connection action whose transaction will be confirmed.
Returns
This action has no returns.
Rules and Conditions
- The Connection field is required.
- This action must be used after SQL Server: Begin transaction.
- After the commit, the operations performed inside the transaction are applied permanently.
- If a failure happens before the commit, use SQL Server: Rollback a transaction to undo the operations.