When creating a new Stored Procedure in SQL Server, at the top of the template it has the following section:

— Use the Specify Values for Template Parameters
— command (Ctrl-Shift-M) to fill in the parameter
— values below.

Well, in SQL 2008 and newer, this keyboard combination was removed. There is a way around this.

The keyboard sequence: Alt-Q-S

You can also get there by the following;

Selecting Query -> Specify Values for Template Parameters…

So now it is up to you. Clear your brain of Ctrl-Shift-M and replace it with Alt-Q-S. Even if it appears on the page.

Leave a Reply

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