---
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: 
  - "Visual Database Tools [SQL Server], queries"
ms.assetid: 65883f21-c898-4857-a0b8-d1851e1486e1
author: markingmyname
ms.author: maghan
ms.manager: jroth
ms.reviewer: 

---
# Copy Query Results (Visual Database Tools)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.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.  
  
### To copy result-set text from the Results pane  
  
1.  Run the query or view that has the data you want to copy.  
  
2.  To select the entire result set, in the **Results** pane, click the top-left empty cell.  
  
3.  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.  
  
4.  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.  
  
5.  Right-click and choose **Copy**.  
  
## See Also  
[Work with Data in the Results Pane (Visual Database Tools)](../../ssms/visual-db-tools/work-with-data-in-the-results-pane-visual-database-tools.md)