SQL Results view

The SQL Results view displays information about actions that are related to running SQL statements, stored procedures, and user-defined functions (UDFs), or creating database objects. For example, when you run a stored procedure on the database server, the SQL Results view displays messages, parameters, and the results of any SQL statements that are run by the stored procedure. The SQL Results view also displays results when you sample the contents of a selected table.

SQL Results view consists of a history pane and a details pane. The history pane displays the history for past queries. The details pane displays the status and results of the last run. Use the view pull-down menu to filter history results and set preferences.

The history pane of the SQL Results view contains the following fields:
History Filter
Enter a query expression in the text field at the top of the SQL Results history pane to filter the results that match the expression.
Status
Shows whether the operation failed, succeeded, terminated, or is still running.
Operation
Displays the SQL statement that was run.
Date
Shows the date and time at which the operation failed, successfully ran, terminated, or reached a breakpoint.
Connection Profile
Shows the connection profile on which the corresponding operation was run.

To save SQL results, right-click the history pane, and select Save History.

When you run multiple queries in a SQL file containing a delimiter (such as go) using the Execute All or Execute Selected Text options, the results are grouped in a tree structure in the SQL Results view. The root node is a top-level result history. Expand this node in the SQL Results view to see the results for each individual SQL statement.

There are two modes for the details pane: single-tab and multi-tab.

To remove an item from the SQL Results view, right-click the item and select Remove. To remove the entire list of items, right-click on the list and select Remove All.


Feedback