RPASQL Server

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.