Query Options Execution (General Page)

  • Article

Use this page to specify the options for running Microsoft SQL Server queries. To access this dialog box, right-click the body of a Query Editor window, and then click Query Options.

  • SET ROWCOUNT
    The default value of 0 indicates that SQL Server will wait for results until all results are received. Provide a value greater than 0 if you want SQL Server to halt the query after obtaining the specified number of rows. To turn this option off (so that all rows are returned), specify SET ROWCOUNT 0.

  • SET TEXTSIZE
    The default value of 2,147,483,647 bytes indicates that SQL Server will provide a complete data field up to the limit of text, ntext, nvarchar(max), and varchar(max) data fields. It does not affect the XML data type. Provide a smaller number to limit results in the case of large values. Columns greater than the number provided will be truncated.

  • Execution time-out
    Indicates the number of seconds to wait before canceling the query. A value of 0 indicates an infinite wait, or no time-out.

  • Batch separator
    Type a word that you use to separate Transact-SQL statements into batches. The default is GO.

  • By default, open new queries in SQLCMD Mode
    Select this check box to open new queries in SQLCMD mode. This check box is visible only when the dialog box is opened through the Tools menu.

    When you select this option, be aware of the following limitations:

    • IntelliSense in the Database Engine Query Editor is turned off.

    • Because Query Editor does not run from the command line, you cannot pass in command-line parameters such as variables.

    • Because Query Editor cannot respond to operating-system prompts, you must be careful not to run interactive statements.

  • Reset to Default
    Resets all values on this page to the original default values.