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.
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: