What are savepoints in SQL and can you give me examples?

What are savepoints in SQL and can you give me examples?

Savepoints in SQL are used to set a point within a transaction that you can roll back to without affecting the entire transaction.

Can you show me a simple example of how to use a savepoint?

Sure! Here's a basic example:

BEGIN;
INSERT INTO employees (name) VALUES ('Alice');
SAVEPOINT savepoint1;
INSERT INTO employees (name) VALUES ('Bob');
ROLLBACK TO savepoint1;
COMMIT;

This will insert Alice but roll back the insertion of Bob.

What happens if I don't use a savepoint?

If you don't use a savepoint, rolling back will undo all changes made in the transaction, not just the last part.

Are there any limitations to using savepoints?

Yes, savepoints can only be used within a transaction, and some databases may have limits on the number of savepoints.