Query Type: Custom

You can write custom SQL queries to execute against the database.

To create a custom query

1. In the Query Type list in the toolbar, click Custom.

2. In the Results pane, type the SQL query in the SQL tab.

3. To view the results, click the Data tab in the Results pane.

You can use the Custom query type to retrieve data from any database. For example, the following query retrieves from the Northwind database the list of employees who live in London. (The Northwind database is a sample database that is shipped with Microsoft SQL Server.)

USE Northwind

SELECT * FROM Employees

WHERE City = 'London';