Creating SQL and XQuery statements in the SQL and XQuery editor by using a database connection

You can use a database connection in the Data Source Explorer view to create SQL and XQuery statements in the SQL and XQuery editor.
Before you begin

The SQL and XQuery editor supports any statement that can be run by the database to which you are connected. If you save the statement, it is stored in a file with the extension .sql.

Prerequisites: Before you create an SQL or XQuery statement by using a database connection:
  • Create a connection profile in the Data Source Explorer and then connect to your database.
  • If you plan to save the statement, create the project in which to store the statement.
Restriction:
  • If you want to reopen the SQL or XQuery statement in the SQL and XQuery editor or the SQL statement in the SQL Query Builder, save the statement in a data project.
  • If you save the statement in a data development project, the project must be associated with a database that contains the database tables that you use in the statement. Otherwise, you cannot run the statement successfully.
About this task

To create an SQL or XQuery statement in the SQL and XQuery editor by using a database connection:

  1. Open the Data perspective.
  2. In the Data Source Explorer view, expand the database connection.
  3. Right-click the database connection or the database, and then click New SQL Script on the pop-up menu.
  4. Specify the SQL or XQuery statement in the SQL and XQuery editor.
  5. Optional: To insert the code pattern of a template into your statement, at the insertion point, type the first few characters of the template name, press Ctrl + Space, and then select the template in content assist.
  6. Optional: To format your SQL or XQuery code, right-click in the editor, and then click Format SQL on the pop-up menu.
  7. Save the statement.
  8. In the Save As window, provide the information about the SQL statement:
    1. Select the project in which to save the SQL statement. If you select a data project, the statement is added to the SQL Scripts folder of the selected project.
    2. Type a file name for the statement.
    3. Click OK

Feedback