I know snippets have been around for years and I have utilised lots of SSMS tools like ssmstoolspack back in the day persuading a company I worked for to buy a copy for the developers. Of late my SSMS tool of choice is ssmsboost, even buying it my self personally, well my company which is more or less the same, they also have a free community version for people involved in the community and they have helped out with Sponsorship several times for Manchester SQL Saturday and Manchester DataPlatform events.
I never really bought into snippets however till I started using Azure Data Studio and wow, so much productivity.
The first thing is to install the Query Editor Boost extension which has several features but the one this post is about is to easily add in snippets
Nothing better than showing by example in several easy steps. This came from trying to write a query without knowing the schema in the database, I know I’ll create a snippet.
1) Ctrl-N for a new SQL file
2) Paste in the code you want to make a snippet of