Design patterns for organizing and structuring SQL stored procedures
Integrating SQL stored procedures into a larger application architecture
How to optimize the performance of SQL stored procedures
Implementing error handling in SQL stored procedures
Using dynamic SQL within a SQL stored procedure