Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

Day 17. Debugging Stored Procedures

On Day 15, "Writing and Executing Stored Procedures," you learned what stored procedures are, how to create them, and how to execute them. In fact, you saw that stored procedures are the way to package a piece of logic for use by any application that is written to access your database. Then, on Day 16, "Optimizing Stored Procedures," you learned how the optimization process works and what the server does when it validates and then compiles the stored procedure. In the process, you saw how you can use temporary tables and the many programming structures and variables in a stored procedure.

Now that you have written a stored procedure, the last thing you need to know is how to test, locate, and fix any problems ...