Add a feature to "Run current statement"
The keyboard shortcut to run Execute statement in query editor is F5. If we have multiple queries in the same query editor window, all the query will be executed, unless we first highlight the part of query that we want to execute, and then pressing F5.
I'm suggesting that instead of selecting the statement (usually by using a mouse movement) and pressing F5, we can just put the cursor anywhere in the statement that we want to run, and then pressing keyboard shortcut (something like ctrl+F5) will run the "current statement" which is the text between the first "newline + newline " above the cursor, and the first "newline + newline" below the cursor. So if we have this text in our query editor's window
1| SELECT *
2| FROM TABLEA
3|
4| SELECT *
5| FROM TABLEB
If we put the cursor anywhere in line 1 or line 2, pressing ctrl+F5 will only run SELECT * FROM TABLEA, and if we put the cursor anywhere in line 4 or line 5, pressing ctrl+F5 will only run SELECT * FROM TABLEB
This features will tremendously saves time when we have a lot of query in one single query editor window.
Version 3.0 is on the site
-
alex smith commented
@Matt Felzani => Remember to vote for : http://devart.uservoice.com/forums/87893-sql-complete/suggestions/5719228-execute-current-statement-key-binding
if you want the keybinding to change.
-
Anonymous commented
Please let us select the keystroke for this.
-
AdminDevart (_, Devart) commented
> Matt Felzani
> Is there a keystroke mapping for the feature?CTRL+SHIFT+E is a keyboard shortcut for the “Execute current statement” command. You can see it in the SQL Complete -> Execute current statement menu. Its absence in the popup menu is the peculiarity of MSSMS 2005 and 2008 behaviour on opening popup menu.
-
Matt Felzani commented
Is there a keystroke mapping for the feature?