Add New Items to a Project
Add new items to a project to extend application functionality. A new item can be a query or a connection. SQL Server Management Studio has two project types: SQL Server Script Project, and Analysis Services Script Project. The project type determines the items that you can add to the project. For example, you can add a Transact-SQL query (a file with a .sql extension) to a SQL Server Script project, but you cannot add it to an Analysis Services Script Project.
SQL Server Management Studio does not allow you to create folders within projects. To organize your work, create multiple projects within the solution.
To add a new query to an existing project
In Solution Explorer, select a target project.
On the Project menu, click Add New Item.
In the Add New Item dialog box, select a category in the left pane.
Select a query template in the right pane, and then click Add. The new query is added in the Queries folder of the project.
In the Connect to Database Engine dialog box, specify a connection for the new query, and then click Connect. You can click Cancel on the connection dialog if you do not want to associate a connection to the new query.
Rename the query in Solution Explorer if you wish.
To add a new connection to an existing project
In Solution Explorer, select a target project.
On the Project menu, click Add New Item.
Select Connection in the left pane.
Select New Connection in the right pane, and then click Add.
In the Connect to Database Engine dialog box, specify a connection for the new query, and then click Connect. The new connection gets added in the Connections folder of the project.
See Also
Solution Explorer
Associate File Extensions to a Code Editor
Add Existing Items to a Project
Remove or Delete an Item or Project