I have a need to handle errors in SQL scripts that i'm working with.<BR><BR>Frequently these errors contain syntax problems and other things like create/drop constraints, not exist.. etc.<BR><BR ...

Once it passes those validations, no more errors are expected and you can pump it over in one statement (well, could be an insert, a delete and maybe even a delete) to the final table.