This topic provides examples that show you how to use SQL Prompt.
You can follow the examples on your own system. The examples in this topic use SQL Server 2005 and you will need access to a SQL Server on which the AdventureWorks example database has been installed.
The following examples are provided:
Before you try this example, ensure the Qualify object names option is selected. To select this option, on the SQL Prompt menu, click Options and then click the Style tab.
The candidate list displays the Suggested candidates category; tables are displayed at the top of the list.
The Contact table is highlighted.
SQL Prompt inserts the table name, qualifies it with the schema name Person, and surrounds the identifiers with brackets [ ].
The candidate list displays column names for the Contact table and associated data types.
By default, when you type an opening quotation mark, SQL Prompt automatically inserts the closing quotation mark.
The candidate list displays columns from the Contact table.
When you type SELECT * and you specify the tables or views in the FROM clause, you can complete the column list by placing the insertion point after the * and pressing TAB.
SELECT * from Contact
SQL Prompt expands the column list.
SQL Prompt also completes the column list for you when you type a SELECT table.* fragment.
SQL Prompt expands the column list, qualifying the columns with the table name and schema (or owner) name.
SQL Prompt inserts the parameters for stored procedures when you type EXEC and you select a stored procedure. Before you try this example, ensure the Insert parameters for functions and stored procedures and Insert hints for data types options are selected; to select these options, on the SQL Prompt menu, click Options and then click the Auto Insert tab.
SQL Prompt displays a list of stored procedures at the top of the candidate list.
The schema panel shows the creation SQL for the highlighted stored procedure.
SQL Prompt inserts the parameters for the stored procedure and inserts the associated data types as comments.
SQL Prompt is pre-configured with default snippets. To see the snippets, press CTRL+SPACEBAR and then CTRL+LEFT ARROW to display the Snippets category.
This example shows you how to insert the snippet code for disabling all triggers on a table.
The candidate list displays a description of the snippet and the schema panel displays the snippet code.
SQL Prompt places the insertion point after TABLE for you to type the table name.
© Red Gate Software Ltd 2007. All Rights Reserved.