--- 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) [!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.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)](../../ssms/visual-db-tools/rename-queries-visual-database-tools.md) [Clear Query Results (Visual Database Tools)](../../ssms/visual-db-tools/clear-query-results-visual-database-tools.md) [Save Queries (Visual Database Tools)](../../ssms/visual-db-tools/save-queries-visual-database-tools.md) [Perform Basic Operations with Queries (Visual Database Tools)](../../ssms/visual-db-tools/perform-basic-operations-with-queries-visual-database-tools.md)