Importing SQL Snippets into Management Studio

Having created one or more snippets, here's how to use them!  First select this menu option in SQL Server Management Studio:

I'm using SSMS for SQL Server 2016, but it should be the same in older and newer versions (provided that you're on at least 2012).

Now choose to add the snippets that you've created:

The choice of language at the top isn't particularly inspiring: SQL or SQL ...

Browse to the folder containing your snippets, and select it:

You can also add individual files, but it seems easier to put all of your snippets into a single folder.

This folder (and any of its subfolders) should immediately appear in the list:

It's a shame Wise Owl comes so late in the alphabet. We did consider calling ourselves Aardvark Training way back in 1992 - perhaps we should have!

You can now add your custom snippets!

The snippet will appear in the appropriate submenu, according to whether it's type is Expansion (as here) or SurroundText.

If only everything in IT was this simple and easy to use!