| title | Copy Query Results | |
|---|---|---|
| ms.custom | seo-lt-2019 | |
| ms.date | 01/19/2017 | |
| ms.prod | sql | |
| ms.prod_service | sql-tools | |
| ms.technology | ssms | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 65883f21-c898-4857-a0b8-d1851e1486e1 | |
| author | markingmyname | |
| ms.author | maghan | |
| ms.manager | jroth | |
| ms.reviewer |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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.
-
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.