Resolving Errors in SQL Query Analyzer

Resolving Errors in SQL Query Analyzer

SQL Server 2000

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.
© 2016 Microsoft