SQL Prompt Quick Access to Helper Code

We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post looks at quick access to snippets.

This is part of a series on SQL Prompt that I’ve written. If you’ve never tried SQL Prompt, it’s amazing. Download an eval today.

The Command Palette from the Query Editor

When typing a query in SSMS, I can hit the CTRL button and get the palette on the side. Here’s a basic query:

I might want to add the begin and end around my code in the proc. If I highlight some code and hit CTLR, I see this:

On the left, I have opened the palette where I can down arrow to pick something relevant or search for a command that helps me. As you can see, the first one is the very common “add begin end” to the code. If I pick this, it will surround my code with begin end, as seen here:

I can also get other helper code, like the CTE outline, as you can see below:

SQL Prompt is amazing, as this video shows. Download an eval today.