Save Queries (Visual Database Tools)
Applies to: 
SQL Server
Save your query when you want to work with it later. Note that running your query does not save your changes.
To save a query
Create your query.
From the File menu, click Save <query_name>.
Note
A newly created query will be given a system name. To choose your own name for the query choose Save<query_name> As.
The query will be saved in the Query folder of the project in Solution Explorer.
See Also
Create Queries
Run Queries
Discard Changes Made to Queries
Design Queries and Views How-to Topics
Types of Queries
Perform Basic Operations with Queries