What is SAVE POINT explain ?

Question

How can I save image in SQL SERVER by VB.NET?

Answer 1

Save points in Oracle can be used for partial rollbacks. For instance we write few SQL statements and don’t want all of them to be committed. We can insert a save point in between and roll back changes until that save point.

Example:

UPDATE emp_name SET salary = salary + 1000 WHERE employee_id = 100;
        DELETE FROM emp_name WHERE employee_id = 130;
        SAVEPOINT do_insert;
        INSERT INTO emp_name VALUES (emp_id, emp_lastname, emp_salary);

On using rollback:

rollback to do_insert;