Data Output view

In the Data Output view, you can see the messages, parameters, results, and profiling data that are related to the database objects that you work with.

The Data Output view displays information about actions that are related to stored procedures and user-defined functions (UDFs). For example, when you run a stored procedure on the database server, the Data Output view displays messages, parameters, and the results of any SQL statements that are run by the stored procedure. The Data Output view also displays results when you sample the contents of a selected table.

The Data Output view includes an actions list on the left side of the view and several tabbed pages on the right side. The pages on the right side display information that is related to the action that is selected in the actions list:

A Messages page displays messages, including the progress of actions.
A Parameters page displays the parameters for a routine or object.
A Results page displays the results of SQL statements that are run by a routine.
A Profiling Data page displays the SQL stored procedure profiling data that is captured when a procedure is run with profiling.

The left side of the Data Output view contains the following fields:

Status: Shows the current state of the statement.
Action: Shows what kind of action occurred.
Object Name: Shows the name of the statement.

To delete an item from the Data Output view, right-click the item and select Delete. To delete the entire list of items, right-click on the list and select Delete all.