Share via

Options (Database Tools/T-SQL Editor/Query Results/Results to Text)

  • Article

Use this page to specify how results appear as text in the Transact-SQL (T-SQL) editor. If you change these options, they will apply only to new instances of the editor. Existing instances will retain the global settings that were in effect when the instance was created.

  • Output format
    You can specify how query results appear in the Results and Messages 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 and Messages 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 and Messages 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.
  • 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.
  • Use Defaults
    You can click this button to reset all options on this page to their default values.

See Also

Tasks

How to: Control the Gathering and Display of Client Statistics

Other Resources

How to: Set Options for Query Execution and Results
Script Analysis and Execution in the Transact-SQL Editor
Options (Database Tools/T-SQL Editor/Query Results/General Page)
Options (Database Tools/T-SQL Editor/Query Results/Results to Grid)
Options (Database Tools/T-SQL Editor/Query Execution/General Page)
Options (Database Tools/T-SQL Editor/Query Execution/Advanced)
Options (Database Tools/T-SQL Editor/Query Execution/ANSI)