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.

    Note

    Because you are not starting SQLCMD from the command line, there are some limitations when running Query Editor in SQLCMD mode. You cannot pass in command-line parameters such as variables, and because Query Editor does not have the ability to 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.