Will try-catch capture all errors that @@error can?
In the following code fragment, is it worthwhile to check for @@error?
Will return 1111 ever occur?
Set xact_abort on.
Catch will only run if an exception is thrown and the catch block can handle that type of exception.
The finally block is the one that will run when the try block is complete.
Delegating the exception from the first catch to a different function or the calling function would be ok, but adding more code which may or may not throw an exception into the first catch, is.
Nope, (or ) is 's friend and always there as part of try/catch.
However, it is perfectly valid to have them empty, like in your example.
In the comments in your example code (if func1 throws.