Customizing inserted code

SQL Prompt - 5.1

Versions available: 5.3, 5.2, 5.1, 5.0, 4.0

Learning SQL Prompt - 5.1

To customize how SQL Prompt inserts suggestions into your code, use the Inserted code pages on the SQL Prompt Options dialog box:

OptionsDialogInsertedCode

To display the SQL Prompt Options dialog box, on the SQL Prompt menu, select Options.

Objects & statements

Contains options for inserting full syntax for various kinds of statement.

For example, you can specify that SQL Prompt inserts column names, data types and default values for ALTER, EXEC and INSERT statements:

FullAlterStatement

Qualification

Contains options for specifying whether object or column names are qualified when inserted.

Note: Object and column names are automatically qualified in certain cases, for example:

When columns in more than one table have the same name, and they need to be qualified to avoid ambiguity (only the affected column names are qualified).
When you insert JOIN conditions from the suggestions box, both column names are qualified.
For cross-database and linked server queries, qualified column names may also include the owner name.

Aliases

Special characters

Contains options for automatically inserting certain characters into your code:

Enclose all identifiers in square brackets
Add parentheses when inserting a function or data type

Note: SQL Prompt displays a tooltip containing the expected parameters whenever you type or insert brackets after a function.
Automatically insert closing characters
Insert the matching closing character when you type a quotation mark, comment character, or bracket.