Using the Solution Explorer
The optional Solution Explorer enables you to organize files and connections within solutions, which then contain projects, similar to the Solution Explorer in Visual Studio. You don't need to use it; File → Open and Save works well without Solution Explorer, but if you work on several database projects, you may find that Solution Explorer helps keep your life organized — or at least your code organized. You can find the Solution Explorer in the View menu, and you can add the Solution Explorer icon to the Standard toolbar using the Customize toolbar.
To use the Solution Explorer for managing query scripts, use the Solution Explorer context menu to create a new project. This creates the nodes and directories for the files. When the project exists, use it to create new queries.
Other than simply organizing your project, the Solution Explorer offers two practical benefits. First, if queries are saved within a solution, bookmarks are retained. Secondly, the Solution Explorer can be used with source control.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
