Export (0) Print
Expand All

Results Pane

The Results pane shows the results of the most recently executed Select query. (The results of other query types are displayed in message boxes.) To open the results pane, open or create a query or view or return a table's data. If the results pane doesn't show by default, from the Query Designer menu, point to Pane, and then click Results.

NoteNote

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

  • View the result set for the most recently executed Select query in a spreadsheet-like grid.

  • For queries or views that show data from a single table or view, you can edit the values in individual columns in the result set, add new rows, and delete existing rows.

  • Results returned by table-valued functions can only be updated in some cases.

  • Queries or views that include columns from more than one table or view can't be updated.

  • Results returned by a stored procedure can't be updated.

  • Queries or views using the GROUP BY or DISTINCT clauses are not updatable.

You can quickly navigate through the records using the navigation bar at the bottom of the Results pane.

There are buttons for going to the first and last records, the next and previous records, and for going to a particular record.

To go to a particular record, type the number of the row in the text box in the navigation bar and then press ENTER.

For information about using keyboard shortcuts in the Query and View Designer see Navigating in the Query and View Designer.

While you're working on the results of a query or view it is possible for the records in the results pane to get out of synchronization with the queries definition. For example, if you ran a query for four out of five columns in a table, then used the Diagram pane to add the fifth column to the definition of the query, that fifth columns data will not automatically be added to the results pane. To make the results pane reflect the new query definition, run the query again.

You can tell if this happens--an alert icon and the text "Query Changed" appears in the lower-right corner of the results pane and the icon is repeated in the upper-left corner of the pane.

Community Additions

ADD
Show:
© 2014 Microsoft