Ad Hoc SQL and the SQL Scratchpad Editor

TDV provides an ad hoc SQL editor a SQL Scratchpad editor that let you execute “anonymous” SQL statements that are not bound to a resource. You can define and execute any SQL statements that can be executed for a composite view.

Ad hoc SQL content and history are saved on the local (Studio instance) machine, and retrieved in the following Studio session.

These topics are covered:

Opening the SQL Scratchpad Editor
Composing and Executing an Ad Hoc SQL Query
The SQL Scratchpad History Pane
The SQL Scratchpad Result Panel

Also refer to the section About TDV SQL Editor for more information about the TDV SQL Editor.