I have a single DBF, where several records need to be updated independent of the rest of the database. However if all records are not updated successfully, then I need to revert the all changes.
I can achieve this with BEGIN TRANSACTION ... END TRANSACTION or with Table Buffering.
Which alternative is recommended and what is faster?
Note that ideally, I do not want to lock the table during this process.