Query results pane

When you execute a query successfully, the results of that query are displayed in the Results pane.

Execution Plan

ApexSQL Edit can display the query execution plan along with the query results. To include the execution plan in your query results, either:

From the Query menu, select Include Actual Execution Plan
From the Query Toolbar, select the Include Actual Execution Plan button ( )

When you select this option, a new tab will be available in the Results Pane, which will display the query execution plan.

Server Trace

ApexSQL Edit includes the ability to trace executed statements. To trace executed statements:

From the Query menu, select Show Server Trace
From the Query Toolbar, select the Show Server Trace button ( )

When this option is selected, a new tab will be available in the Results pane, which will display the server trace results.

Note:

You can define the type of trace to perform, along with other tracing settings, in the Application Options.

Result Views

You can control the way that ApexSQL Edit displays query results by right clicking query results and selecting from the Grid View menu.

Table Grid – This option will display the query results in a sortable table
Single Row – This will display the values for each row in a separate “card” and only display one “card” at a time
Multiple Row – This will display the values for each row in a separate “card” and display multiple “cards” at once

Filter Row

At the top of the results pane is the filter row. Each column of results can be filtered to display only those results that match the value you enter here.

In addition, you can set up the filter row to display a drop down list for specific columns. This list will include all values for that row and allow you to quickly select the value you want to filter for. To set up filter lists:

From the Tools menu, select Manage Filtered Columns
Select the columns that you want to filter using drop down lists
Execute your query

XML and Text Views

One useful feature of the Results pane is the ability to view your query results in a basic text format, or in a XML document format.

To switch to a text format, right click your query results and select Switch to Text View
To view your results as a formatted XML document, right click your query results and select Switch to XML View
To switch back to the standard grid view, right click your results and select Switch to Grid View