copy-queries-visual-database-tools.md

title	Copy Queries
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	copying queries queries [SQL Server], copying
ms.assetid	46cd1557-cf3d-40b8-b489-8446e0984e0f
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Copy Queries (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] You can copy the body of a query into a new query to use as a starting point.

To copy a query

1. From the View menu, click Solution Explorer.

2. In Solution Explorer, right-click the query you want to copy and from the shortcut menu choose Open.

3. In the SQL pane, copy the portion of the query you want to copy.

4. Create a new query or open the query where you want to paste the copied SQL.

5. Position the cursor where you want to add the SQL code.

6. Right-click and from the shortcut menu click Paste.

See Also

Rename Queries (Visual Database Tools)
Clear Query Results (Visual Database Tools)
Save Queries (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)