Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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.