SQL Server - Begin transaction
SQL Server - Begin transaction
Begins a transaction on a SQL Server connection. It lets you group several SQL operations into one atomic unit — all of them are applied with SQL Server: Commit a transaction or undone with SQL Server: Rollback a transaction.
Options
Connection
Reference to the SQL Server: Connection action the transaction will be started on.
Returns
This action has no direct returns. Its ID is used as a reference by the transaction's commit and rollback actions.
Rules and Conditions
- The Connection field is required.
- The transaction must be finished with SQL Server: Commit a transaction to confirm the operations, or with SQL Server: Rollback a transaction to undo them.
- The queries run inside the transaction must reference the same connection used in this action.