ROLLBACK TRANSACTION Statement [T-SQL]

Cancels any changes made since a savepoint was established using SAVE TRANSACTION. Changes made prior to the SAVE TRANSACTION are not undone; they are still pending.

Quick Links:

Go to Parameters

Go to Examples

Go to Standards

Go to Permissions

Syntax

ROLLBACK TRANSACTIONsavepoint-name ]

Parameters

(back to top)

Examples

(back to top)

Standards

(back to top)

  • SQL–Vendor extension to ISO/ANSI SQL grammar.

Permissions

(back to top)

None, but there must be a corresponding SAVE TRANSACTION within the current transaction.
Related reference
BEGIN TRANSACTION Statement [T-SQL]
SAVE TRANSACTION Statement [T-SQL]