How to: Copy Queries
You can copy the body of a query into a new query to use as a starting point.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To copy a query
From the View menu, click Solution Explorer.
In Solution Explorer, right-click the query you want to copy and from the shortcut menu choose Design.
In the SQL pane, copy the portion of the query you want to copy.
Create a new query or open the query where you want to paste the copied SQL.
Position the cursor where you want to add the SQL code.
Right-click and from the shortcut menu click Paste.