I sometimes see people miss this. A very resourceful feature is the Template Explorer in SQL Server Management Studio. Here’s how to take advantage of it:
3. After you do so, it’ll open up a new query window with the source of the snippet.
4. Do CTRL+SHIFT+M to fill in the parameters: