Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

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 ...