terminates an SQL transaction.
returns to an SQLSavepoint.
Details and Options
- To use SQLRollbackTransaction, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.
Basic Examples (1)
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.
The table only contains data inserted after the rollback: