SSMS Template Explorer (Snippets)
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:
1. First you show the panel in SQL Server:
2. Double click on the snippet/template. We’ll double click on the Create Multi-statement table-value Function:
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:
Categories