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

We’ll work with the first syntax, which directs the flow to a special error-handling routine, where line identifies that routine, within the procedure. A generic line follows: ...