Contents
What is a database 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.
What is database rollback in Salesforce?
database.savepoint is a method which is used to define a point which can be roll back to. If any error occurs during a transaction, that contains many statements, the application will roll back to the most recent savepoint and the entire transaction will not be aborted.
What is savepoint in Salesforce?
Apex gives you the ability to generate a savepoint , that is, a point in the request that specifies the state of the database at that time. Each savepoint you set counts against the governor limit for DML statements. Static variables are not reverted during a rollback.
How to use rollback and savepoint in SQL?
SQL> SELECT * FROM emp_data; NO NAME CODE 1 Opal e1401 2 Becca e1402 SQL ROLLBACK command execute at the end of current transaction and undo/undone any changes made since the begin transaction. Above example we are create 3 SAVEPOINT table_create, insert_1 and insert_2.
How are commit, rollback and savepoint commands used?
Commit, Rollback and Savepoint SQL commands. Transaction Control Language(TCL) commands are used to manage transactions in the database. These are used to manage the changes made to the data in a table by DML statements. It also allows statements to be grouped together into logical transactions.
When to use the savepoint command in SQL?
SAVEPOINT command is used to temporarily save a transaction so that you can rollback to that point whenever required. In short, using this command we can name the different states of our data in any table and then rollback to that state using the ROLLBACK command whenever required. Lets use some SQL queries on the above table and see the results.
When to use the rollback command in SQL?
ROLLBACK command. This command restores the database to last commited state. It is also used with SAVEPOINT command to jump to a savepoint in an ongoing transaction. If we have used the UPDATE command to make some changes into the database, and realise that those changes were not required, then we can use the ROLLBACK command…