Eduardo Pivaral shows us how to use snippets in SQL Server Management Studio:
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have stored them on a folder and you open them manually as you need them, or have saved them on a solution or project file, maybe you execute a custom .bat or PowerShell file to load them when you open SSMS…
Every method has its pros and cons, and on this post, I will show you a new method to load your custom scripts on any open query window on SSMS via Snippets.
Click through for more details, including an example. Snippets are a good tool implemented adequately in SSMS. A few third-party extensions make working with snippets better and really valuable (until you’re stuck on a machine without your snippets).