LESSON 23Debugging Your SQL Statements
In this lesson, you will see various common errors that everyone—from novice to professional users—makes when using SQL. You will never be able to avoid all errors and/or mistakes, but being familiar with a wide range of errors will help you resolve them in as short a time as possible. By the end of this lesson, you will be familiar with the following:
• Several typical errors and their resolutions
• Common logical shortcomings of SQL users
• Ways to prevent daily setbacks caused by errors
Keep in mind that some mistakes will actually yield error messages, whereas others might just be inadequacies in logic that will inevitably cause more significant errors or problems down the road. With a strict attention ...