SSMS Tips: Templates and Control+Shift+M

Templates-Code-RecyclingDo you use templates to save typing in SQL Server Management Studio?

Templates are extremely handy for tasks that you need to do repeatedly, but with different parameter values. The coolest part is that once you get the hang of them, you can create your own custom templates.

Whether or not you’re using a template, always make sure that you’re connected to the right server before you hit execute. Don’t ask me how I know to mention that reminder 😉

Here’s a demo of how to use a simple template. Use the keyboard shortcut Control+Shift+M to open the template parameter editor.

The mnemonic I use to remember the shortcut is “Control and Shift Microsoft!” (Does that make me sound like a power hungry person? Hmmm.)


Previous Post
Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)
Next Post
Teach Yourself SQL Server Performance Tuning (Dear SQL DBA Episode 12)

Related Posts

13 Comments. Leave new

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.