Have you ever looked in amazement at your SQL guru who can whip up in a flash a fancy TSQL script to run?
Today I will share with you a super handy feature in SQL Server Management Studio (SSMS) called Solutions. Quite similar to Visual Studio solutions, you can create a solution(s) in SSMS with projects. Inside the projects you can then store all your favorite scripts.
Sounds great; so let me show you how in 5 minutes.
- OpenSSMS and press CTR+Shift+N.
- Now you will see this screen.
- Add a name.
- Hit ok.
- Back in SSMS you will notice Solution Explorer open with your new project added.
- Right click on “Queries”
- Select “New Query”
Congratulations on your first SSMS Project with a query.
Once you close SSMS it will prompt to save your solution and any open queries. Once confirmed it will save your scripts for use next time.
Now all you need to do is start build your own little pearls of wisdom and amaze the next future guru.