Options (Database Tools/T-SQL Editor/Query Execution/General Page)
Use this page to specify the options for running queries and scripts 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 maintain the global settings that were in effect when that instance of the editor was created.
- SET ROWCOUNT
If you specify a non-zero value, results will include only the number of rows that you specified. If you specify 0, Microsoft SQL Server will return all rows that meet the criteria of the query. The default value is 0.
- SET TEXTSIZE
If you specify a value, results will include only the number of bytes that you specified for text, ntext, varchar(max), nvarchar(max), varbinary(max), and image fields. The default value of 2,147,483,647 bytes will return the complete content of these fields.
- Execution time-out
If you specify a non-zero value, SQL Server will wait the specified number of seconds for results before it cancels a query. The default value of 0 specifies an infinite wait (in other words, no time-out). You must specify a value between 0 and 32000.
- Batch separator
You specify the word that will be used to separate T-SQL statements into batches. The default value is GO.
- Open new queries in SQLCMD mode
If you select this check box, new queries open by default in SQLCMD mode and allow you to execute SQLCMD commands along with T-SQL statements. If this check box is cleared and you use a SQLCMD command, an error message appears. By default, this check box is selected.
- Use Defaults
You can click this button to restore all settings 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 Execution/ANSI)
Options (Database Tools/T-SQL Editor/Query Execution/Advanced)