Transact-SQL Editor Options (Query Results/Text)

Article
02/20/2011

Use this page to specify how results appear as text in the Transact-SQL editor. If you make changes with the Options dialog box, they will apply only to new instances of the editor. Existing instances will maintain the global settings that were in effect when that instance of the editor was created. If you make changes with the Query Options dialog box, they will apply only to the active Transact-SQL editor window. For more information, see How to: Set Options for Query Execution and Results.

Output format
You can specify how query results appear in the Results tab of the Results pane. If you click Column-aligned, each column appears as a fixed width, padding as needed. This option is the easiest to read. The delimited formats provide output that might be easier to import into other tools. If you specify Custom-delimiter, the Custom-delimiter box appears so that you can specify your custom-delimiter character. By default, this option is set to Column-aligned.
Custom delimiter
This box appears only if you specify custom-delimiter for the output format. Type the custom-delimiter character that you want to use. By default, this box is empty.
Include column headers in the result set
If you select this check box, column headings appear on the Results tab. If you clear this check box, no column headings appear. By default, this check box is selected.
Include the query in the result set
If you select this check box, the query appears on the Results tab of the Results pane after you execute a query. The query is enclosed within comment delimiters (/* */). By default, this check box is cleared.
Scroll as results are received
If you select this check box, the Results pane continuously scrolls to display additional results if the results are too numerous to appear at the same time. If this check box is cleared, only the first page of the results set appears. By default, this check box is cleared.
Right-align numeric values
This check box is available only if you specified Column-aligned for the output format. If you select this check box, numeric values are aligned with the right-most edge of their column. If you clear this check box, numeric values will be left-aligned. By default, this check box is cleared.
Discard results after query executes
Select this check box to discard the query results after they are displayed in the results pane of the query window.
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
Select this check box to automatically set the screen focus to the result set.
Maximum number of characters displayed in each column
This check box specifies the maximum number of characters that appear in a column. Any additional characters are truncated. By default, this value is 256.
Reset to Default
You can click this button to reset all options on this page to their default values.

Share via

Transact-SQL Editor Options (Query Results/Text)

See Also

Tasks

Reference

Concepts

Additional resources