This next example shows how SQL Prompt can complete the column list for you when you type a SELECT table.* fragment and press TAB.
Ensure that Qualify object names is selected on the Inserted Candidates, Formatting options page. In the first example, you type SELECT * and you specify the tables or views in the FROM clause you can then complete the column list by placing the insertion point after the * and pressing TAB: These examples show you how SQL Prompt can expand a column list when you are using a SELECT statement. Press COMMA, type L, and then press ENTER to insert the LastName column. Type f and press ENTER to insert the FirstName column. For more information, see Troubleshooting If you do not type * the candidate list may display incorrect candidates. Note that you must always type * after the SELECT keyword, even when you want use SQL Prompt to insert the column list later. The candidate list displays columns from the Contact table. Delete the * (after SELECT) and press CTRL+SPACEBAR to display the candidate list. You can change this setting and other auto-completion options, on the Auto Insert, Closing Characters options page. If you type the closing quotation mark (for example, because you have not noticed the automatic insertion), SQL Prompt overtypes the auto-inserted quotation mark. 
Type LIKE 'Fr%' so that your query returns rows where LastName begins with Fr.īy default, when you type an opening quotation mark, SQL Prompt automatically inserts the closing quotation mark. Type L and press ENTER to insert the LastName column. The candidate list displays column names for the Contact table and associated data types. The identifiers are surrounded with brackets this is another option in Inserted Candidates, Formatting, which you can switch off if required. Because you selected the Qualify object names option, SQL Prompt qualifies the table name with the schema (owner) name Person. Press ENTER to insert the Contact table. Type c to filter the list by candidates that begin with c. The candidate list displays the Suggested candidates category tables are displayed at the top of the list. On the Options dialog box, click the Inserted Candidates tab, click the Formatting page, and then select the Qualify object names check box and click OK. This example shows you how you can use the SQL Prompt candidate list to assist you when you are typing a query. To do this on the SQL Prompt menu, click Options, and then click Restore All Defaults. In addition, the cross-database queries and queries using linked SQL Servers examples use SQL Server 2000 on which the Northwind and pubs example databases have been installed.īefore you follow the examples, to ensure that you see the same results as those illustrated, set your options to the default values. Most 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. You can follow the examples on your own system. Cross-database queries and queries using linked SQL Servers. 
This topic shows you how you can use SQL Prompt.
0 kommentar(er)
