Answer:Will using a savepoint in the middle of a transaction save all that happened before it automatically?
No. A savepoint comes into play only if a ROLLBACK command is issued--and then only the changes made after the savepoint will be rolled back.