Query Options Results (Text Page)
Collapse the table of content
Expand the table of content

Query Options Results (Text Page)


Use this page to specify the options for displaying a query result set in text format. The settings on this page also apply when Results to File is selected.

Output format

By default the output is displayed in columns created by padding the results with spaces. Other options are using commas, tabs, or spaces to separate columns. Select the Custom delimiter check box to specify a different delimiting character in the Custom delimiter box.

Custom delimiter

Specify the character of your choice to separate columns. This option is only available if the Custom delimiter check box is selected in the Output format box.

Include column headers in the result set

Clear this check box if you do not want each column labeled with a column title.

Scroll as results are received

Select this check box to keep the display focus on the most recently returned records at the bottom. Clear this check box to keep the display focus on the first rows received.

Right align numeric values

Select this check box to align numeric values to the right of the column. This can make it easier to review numbers with a fixed number of decimal places.

Discard result after query executes

Frees memory by discarding the query results after the screen display has received them.

Display results in a separate tab

Select this check box to display the result set in a new document window, instead of at the bottom of the query document window.

Switch to results tab after the query executes

Click to automatically set the screen focus to the result set.

Maximum number of characters displayed in each column

This value defaults to 256. Increase this value to display larger result sets without truncation.

Reset to Default

Resets all values on this page to the original default values.

To save query results as a text file with headers, select the Include column headers in the result set check box and a delimited output format. Now the report file will contain headers when you click Results to File on the toolbar, or when you right-click any query results, click Save Results As, type a file name, and then click Save.

Community Additions

© 2015 Microsoft