Options (Database Tools/T-SQL Editor/Query Results/Results to Grid)
Use this page to specify how results appear as a grid 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.
- Include the query in the result set
If you select this check box, execute a query, and show the results as a grid, the query will appear on the Messages tab of the Results pane as a comment. By default, this check box is cleared.
- Include column headers when you copy grid content
If you select this check box and then copy data from the grid to the Clipboard, you will also copy the column headers. If you clear this check box, you will copy only the data in the grid, not the column headers. By default, this check box is cleared.
- Maximum characters retrieved for non-XML
You can specify the maximum number of characters that are retrieved for columns that do not contain XML. By default, the value for this option is 65535.
- Maximum characters retrieved for XML
You can specify the maximum size of the XML data that is retrieved for columns that contain XML. You can specify 1 MB, 2 MB, 5 MB, or Unlimited. By default, the value for this option is 2MB.
- 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 Text)
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)