How to: Copy Query Results (Visual Database Tools)
New: 17 July 2006
You can copy the result set as tab-separated text from the Results pane. You may copy the entire result set or any number of contiguous or non-contiguous rows or cells.
To copy result-set text from the Results pane
Run the query or view that has the data you want to copy.
To select the entire result set, in the Results pane, click the top-left empty cell.
To select rows:
- Select one row by clicking the box to the left.
- Select multiple contiguous rows by selecting one row and then dragging the mouse to select additional rows.
- Select non-contiguous rows by selecting one row, then holding down the CTRL key and clicking additional rows.
The selected rows will be highlighted.
To select cells:
- Select a single cell by clicking the value.
- Select multiple cells by dragging the mouse to adjacent cells.
- Select non-contiguous cells by selecting a single cell, then holding down the CTRL key and clicking additional cells.
The selected cells will be highlighted.
Right-click and choose Copy.
See Also
Concepts
Working with Data in the Results Pane (Visual Database Tools)