Resolving Errors in SQL Query Analyzer
SQL Query Analyzer provides several tools to help you prevent and resolve errors.
- Use the color-coding in the Editor pane to help eliminate errors.
Using the default colors as examples, if you type a keyword not displayed in blue, the keyword may be misspelled. If much of your code is displayed as red, you might have omitted the closing quotation mark for a character string.
- To parse syntax without executing the code, click the Parse button.
- If an error occurs, double-click the error message to locate the line that contains the error in your code.
- To debug stored procedures, use the Transact-SQL Debugger.