Write custom SQL queries

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 available from Microsoft.)

USE Northwind

SELECT * FROM Employees

WHERE City = 'London';