Results Pane

  • Article

The Results pane shows the results of the most recently executed Select query. (The results of other query types are displayed in message boxes.)

In the Results pane you can:

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

  • Edit the values in individual columns in the result set, add new rows, and delete existing rows. For details, see Editing Rows in the Results Pane.

If you change the query definition (for example, add another output column to the query), the Query Designer dims the Results pane to indicate that it no longer reflects the current query. However, you can still navigate in the Results pane grid to edit, add, or delete rows.

Data in the Results Pane

When you execute a Select query, open a view, or open a table, the result set appears in the Results pane.

The Results pane uses these conventions:

  • Columns containing no value display the word <NULL>.

  • Columns containing binary data display the word <Binary>. You cannot edit the contents of these of columns.

  • Columns containing long varchar-type data display up to 900 characters of data. If the data is longer, the cell displays <Long Text>.

  • Columns format number, currency, time, and date information according to the options set in the Regional Settings dialog box in the Microsoft® Windows® Control Panel.

See Also

Adding New Rows in the Results Pane | Deleting Rows in the Results Pane | Determining When Query Results Can Be Updated | Editing Rows in the Results Pane | Removing Columns from Query Output | Reordering Output Columns