Transaction processing

Savepoint

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. 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). (Wikipedia).

Video thumbnail

PowerPoint 2010: Saving Presentations

In this video, you’ll learn more about saving presentations in PowerPoint 2010. Visit https://www.gcflearnfree.org/powerpoint2010/saving-and-printing/1/ for our text-based lesson. This video includes information on: • Using the Save command • Using AutoRecover • Saving to other file forma

From playlist Microsoft PowerPoint 2010

Video thumbnail

PowerPoint 2016: Saving Presentations

In this video, you’ll learn the basics of saving presentations in PowerPoint 2016. Visit https://www.gcflearnfree.org/powerpoint2016/saving-presentations/1/ for our text-based lesson. This video includes information on: • Using OneDrive to save • Using Save As to make a copy • Using AutoR

From playlist Microsoft PowerPoint 2016

Video thumbnail

How to Work with Wikipedia Sandbox

This is a short video that helps students or editors of Wikipedia to access and edit in the Sandbox of their user account. This was made for the Wiki Edu Project. I do not own or hold copyright over any aspect of the Wikipedia site or its pages. ***There is no audio***

From playlist Wikipedia Education Dashboard Tutorials

Video thumbnail

PowerPoint: Saving and Sharing

In this video, you’ll learn more about saving and sharing in PowerPoint 2019 and Office 365. Visit https://edu.gcfglobal.org/en/powerpoint/saving-presentations/1/ for our text-based lesson. This video includes information on: • Using Save and Save As to save presentations • Using AutoReco

From playlist Microsoft PowerPoint

Video thumbnail

Excel 2010: Saving

In this video, you’ll learn more about saving in Excel 2010. Visit https://www.gcflearnfree.org/excel2010/saving/1/ for our text-based lesson. This video includes information on: • Saving workbooks • Using AutoRecover • Saving as an Excel 97-2003 workbook • Saving as a PDF We hope you en

From playlist Microsoft Excel 2010

Video thumbnail

PowerPoint 2013: Saving and Sharing Presentations

In this video, you’ll learn more about saving and sharing presentations in PowerPoint 2013. Visit https://www.gcflearnfree.org/powerpoint2013/saving-and-sharing/1/ for our text-based lesson. This video includes information on: • Using Save As to make a copy • Using AutoRecover • Exporting

From playlist Microsoft PowerPoint 2013

Video thumbnail

PowerPoint: Getting Started

In this video, you’ll learn the basics of getting started in PowerPoint 2019, PowerPoint 2016, and Office 365. Visit https://edu.gcfglobal.org/en/powerpoint/getting-started-with-powerpoint/1/ for our text-based lesson. This video includes information on: • Working with the PowerPoint envi

From playlist Microsoft PowerPoint

Video thumbnail

PowerPoint

If you are interested in learning more about this topic, please visit http://www.gcflearnfree.org/ to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

From playlist Microsoft PowerPoint

Video thumbnail

Animate Anything in Microsoft PowerPoint

If you like this video, drop a comment, give it a thumbs up and consider subscribing here: https://www.youtube.com/channel/UCrdjXR70BwWIX--ZtQB42XQ?sub_confirmation=1 Music from: YouTube Audio Library Check out our new project: https://magnimetrics.com Automated Financial Analysis. Reinv

From playlist Tutorials and Edits

Video thumbnail

Excel: Saving and Sharing

In this video, you’ll learn more about saving and sharing files in Excel 2019 and Office 365. Visit https://edu.gcfglobal.org/en/excel/saving-and-sharing-workbooks/1/ for our text-based lesson. This video includes information on: • Using the Save and Save As features • Using AutoRecover •

From playlist Microsoft Excel

Related pages

Database transaction | Nested transaction | Rollback (data management)