Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can copy the body of a query into a new query to use as a starting point.
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 Open.
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.
See Also
Tasks
How to: Rename Queries (Visual Database Tools)
How to: Clear Query Results (Visual Database Tools)
How to: Save Queries (Visual Database Tools)
Other Resources
Performing Basic Operations with Queries (Visual Database Tools)