Debugging Explained
The process of debugging is the least favorite task that a programmer must perform. Debugging means nothing more than finding the problems that are preventing your program code from performing properly and fixing it. To prevent these problems from occurring when the application is executed, you must take the time to test your stored procedures, triggers, functions, and batches. The best way to debug your SQL code is to take the time to plan and design the code before you start writing it. In addition, you should create a list of the conditions that you want to test in the code. As your SQL programs become more complex, you will find that testing will also become more difficult.
It is very important for you to take the time ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
