A savepoint is a way of implementing subtransactions (also known as nested transactions) within a relational database management system by indicating a point within a transaction that can be "rolled back to" without affecting any work done in the transaction before the savepoint was created. Multiple savepoints can exist within a single transaction. Savepoints are useful for implementing complex error recovery in database applications. If an error occurs in the midst of a multiple-statement transaction, the application may be able to recover from the error (by rolling back to a savepoint) without needing to abort the entire transaction.
A savepoint can be declared by issuing a SAVEPOINT name statement. All changes made after a savepoint has been declared can be undone by issuing a ROLLBACK TO SAVEPOINT name command. Issuing RELEASE SAVEPOINT name will cause the named savepoint to be discarded, but will not otherwise affect anything. Issuing the commands ROLLBACK or COMMIT will also discard any savepoints created since the start of the main transaction.
savepoint, save, points, video, games, saved, game, this, article, needs, additional, citations, verification, please, help, improve, this, article, adding, citations, reliable, sources, unsourced, material, challenged, removed, find, sources, news, newspapers. For save points in video games see Saved game This article needs additional citations for verification Please help improve this article by adding citations to reliable sources Unsourced material may be challenged and removed Find sources Savepoint news newspapers books scholar JSTOR September 2014 Learn how and when to remove this template message A savepoint is a way of implementing subtransactions also known as nested transactions within a relational database management system by indicating a point within a transaction that can be rolled back to without affecting any work done in the transaction before the savepoint was created Multiple savepoints can exist within a single transaction Savepoints are useful for implementing complex error recovery in database applications If an error occurs in the midst of a multiple statement transaction the application may be able to recover from the error by rolling back to a savepoint without needing to abort the entire transaction A savepoint can be declared by issuing a SAVEPOINT i name i statement All changes made after a savepoint has been declared can be undone by issuing a ROLLBACK TO SAVEPOINT i name i command Issuing RELEASE SAVEPOINT i name i will cause the named savepoint to be discarded but will not otherwise affect anything Issuing the commands ROLLBACK or COMMIT will also discard any savepoints created since the start of the main transaction Savepoints are defined in the SQL standard and are supported by all established SQL relational databases including PostgreSQL Oracle Database Microsoft SQL Server MySQL IBM Db2 SQLite since 3 6 8 Firebird H2 Database Engine and Informix since version 11 50xC3 Retrieved from https en wikipedia org w index php title Savepoint amp oldid 1078296840, wikipedia, wiki, book, books, library,
