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.
- In single-tab mode, all results and messages appear in the same column,
with messages and status at the end.
- In multi-tab mode, each result and message is in a separate tab. Tabs
appear only when there is content to display. For example, if you run a stored
procedure that does not produce any results, the Results tab
does not appear.
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.