I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool. SQL Prompt will be yours as well if you give it a try.
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which comes about from pressing Shift+F5. Whatever statement the cursor is on, whether it’s a single line or multi-line, the statement will execute.
It can be on the first line:
the last line
the end of the line
It doesn’t matter. When I press Shift+F5 in all of these cases, I get this:
Only the second statement executed (the SELECT), the first statement is ignored (and all other statements) and the code executed is highlighted.
As mentioned at SQLServerCentral, there’s a caveat. This isn’t really highlighting, it’s just coloring. Read the article to understand the difference.
I also have a video version of my tip.
You can see a complete list of SQL Prompt tips at Redgate.