How do you code error handling logic in your stored procedures?

Answer 1

*    Use the TRY and CATCH commands with BEGIN and END blocks.
*    The error handling can be consolidated by creating a single stored procedure to write the data to a centralized table.
*    Use the RAISERROR command.

Answer 2

am all for abstractions and separations of logic. I definately do not believe that T/SQL or PL/SQL are expressive enough languages to describe that logic. Sticking critically meaningful code in the DB from what I've always encountered leads to the Clusterous Fucokous Anti-pattern.