SUSPEND TRANSACTION

SUSPEND TRANSACTION

Does not require any parameters

Description

The SUSPEND TRANSACTION command pauses the current transaction in the current process. You can then handle data in other parts of the database, for example, without it being included in the transaction, and while preserving the transaction context untouched. Any records that have been updated or added in the transaction are locked until the transaction is resumed using the RESUME TRANSACTION command.

For more information, please refer to the Suspending transactions section.

See also

Active transaction
RESUME TRANSACTION
Suspending transactions