General question about SavePoint

[Garth WIlcox]

The documentation for SavePoint states: "Identifies a point in a transaction to which you can later roll back. In the parameter, you can pass any name to identify the savepoint."

Does SavePoint also commit all prior work for the transaction?

If a transaction has started, inserts made and a SavePoint has been created; does Rollback rollback to the start of the transaction?

 

[Marco Kalter]

A Savepoint does not commit any prior work of the transaction. A "rollback to savepoint x" will undo all changes made since savepoint x was established. A "rollback" (without a savepoint) will undo all changes made within the transaction, including all savepoints.