Using SQL Query Analyzer Windows

Using SQL Query Analyzer Windows

SQL Server 2000

SQL Query Analyzer provides several windows in which to work:

  • Query window

  • T-SQL Debugger window

  • Open Table window
Query Window

The title bar of the query window displays the name of the database server, the name of the current database, the current login name, and the query name. If the query is saved to a file, the complete path to the file is shown.

The query window is composed of multiple panes. The Editor pane is a text editor where you can enter Transact-SQL statements. The Results pane displays returned result sets. The Messages pane displays error messages. The Execution Plan pane displays a graphical representation of an execution plan. The Trace pane displays server trace information. The Statistics pane displays statistics information.

Click a pane to make it the active pane. Alternatively, press SHIFT+F6 to move between panes.

T-SQL Debugger Window

The Transact-SQL Debugger window is composed of multiple panes. The Code pane displays the SQL statements being debugged. In addition, the Transact-SQL debugger presents separate output windows for local and global variables, and for the output (result set) of the query. Note that global variable is a legacy term for the Transact-SQL built-in functions whose names start with @@.

Open Table Window

The Open Table window displays the columns and rows from a table in a grid. You can modify the data in the grid. You can also insert and delete rows.

Attempts to insert, delete, or update a column referenced by a computed column may fail under certain conditions. If an index exists on the computed column, then user option ARITHABORT must be enabled by default before you can edit the referenced column. To enable ARITHABORT, execute the following set of commands on your server:

sp_configure 'user options', 64
© 2015 Microsoft