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.
Unlimited or Fixed size (records)
Select Unlimited to return all records. Select Fixed size and then in the text field, set the maximum number of records to be returned. (Default fixed size: 1000)
Maximum characters per column: (Default: 256)
Specify how wide each column should be in the Resultn tab in the lower pane of the SQL Worksheet window.
Discard results: (Default: cleared)
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:
Output format (Default: Column aligned)
Select between Column aligned, Comma separated (CSV), Tab delimited, or Other delimiter.
Right aligned numerics: (Default: cleared)
When you select Column aligned for the Output format, specify whether or not to right align number columns.
Delimiter
When you select Other delimiter for the Output format, specify the character to be used as the delimiter between the columns.
Display headers:
Specify whether or not the column names are displayed.
The SQL Scanner settings are used to define the requirements for the SQL Scanner module.
SQL Scanner Abstract Plan Settings
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.
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center