Data Access Interview Question:

Explain What is SAVE POINT?

Submitted by: Administrator

For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
Submitted by: Administrator