Session 6: Visual Query Builder

Go Up to Rapid SQL Tutorial exercises

Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.

1. From the Navigator tree, right-click on the HumanResources.Employee table and select Build Query.

   The table is automatically added to the Query Builder workspace.

2. On the Tables/Views tab, right-click on the Department table and select Add.
3. Similarly, on the Tables/Views tab, right-click on the EmployeeDepartmentHistory table and select Add.
4. Rearrange the contents of the window to look like the following graphic.
5. Select the columns indicated in the graphic.

   

   Note that the tables are automatically identified as being joined by any columns with the same name and datatype. Also, note that the query is being built in the lower pane.

6. Click on the DML tab to expose the visual query building clauses and options. You can right-click on any clause to easily add the code to the query.

   

7. Experiment with adding, deleting, and modifying clauses.
8. Click the Execute button to execute the query.

   

   The results will display in the lower window.

Before closing the Query Builder, experiment with additional options. Try selecting a different statement type, such as Insert or Update, from the dropdown at the top of the Query Builder window. Use the different clauses on the DML tab.

Note: Any visual query builder session can easily be saved to a file for later use.

Proceed to Session 7: Live Data Editor.