Copy Queries (Visual Database Tools)

Applies to: SQL Server

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)