The SQL Worksheet tab of the Preferences window allows users to determine if the commands are clear upon execution, the batch separator, the buffer size for the result set, and to specify how the results sets are displayed.
Clear commands upon execution (Default = checked)
Specify to clear the SQL statement or Transact-SQL code in the Editor pane after the command is successfully executed. If the execution is not successful, then the text remains in the Editor pane.
If this option in not selected, the text also remains in the Editor pane.
Note: After a successful execution, the text is always saved in the Command drop-down field at the top of the window.
Batch Separator (Default: GO)
Specify the separator used to signal the end of a batch of Transact-SQL statements.
Specify how wide each column should be in the Resultn tab in the lower pane of the SQL Worksheet window.
Specify whether to show the results on the Resultn tab, or to just show the number of affected records on the Message Log tab.
Display results in
Grid or Text: Select between displaying the results in a grid or in plain text.
Under the Text option you can also select:
Right aligned numerics: (Default: cleared)
When you select Column aligned for the Output format, specify whether or not to right align number columns.
When you select Other delimiter for the Output format, specify the character to be used as the delimiter between the columns.
Specify whether or not the column names are displayed.
The SQL Scanner settings are used to define the requirements for the SQL Scanner module.
The settings in the SQL Classification tab are used by the SQL Scanner to help you identify which SQL statements are likely to be causing performance problems by classifying the SQL as Problematic, Complex, or Simple.