Skip to main content
Docs
Go to the Studio
Roberty Studio
RPASQL Server

SQL Server - Rollback a transaction

SQL Server - Rollback a transaction

Undoes every operation performed inside a SQL Server transaction begun with SQL Server: Begin transaction. Useful for error handling — when a failure happens, rolling the transaction back guarantees that no partial change is written to the database.


Options​

Transaction​

Reference to the SQL Server: Begin transaction action whose transaction will be rolled back.

Returns​

This action has no returns.

Rules and Conditions​

  • The Transaction field is required.
  • This action must be used after SQL Server: Begin transaction.
  • After the rollback, every operation performed inside the transaction is undone.
  • This action is usually used in the flow's error handling blocks.