We’re pleased to announce a new beta version of SQL Prompt. We’ve been trying out a few new core technologies, and used them to add features and bug fixes suggested by users on theÂ SQL Prompt forumÂ andÂ suggestions forum.
You can download the SQL Prompt 6.4 betaÂ hereÂ (zip file). Let us know what you think!
Execute current statement
In a query window, you can now execute the SQL statement under your cursor by pressingÂ Shift + F5.
For example, if you have a query containing two statements and your cursor is placed on the second statement:
When you pressÂ Shift + F5, only the second statement is executed:
You can now use SQL Prompt to automatically insert missing semicolons after each statement in a query.
To insert semicolons, go to the SQL Prompt menu and clickÂ Insert Semicolons.Â Alternatively, holdÂ CtrlÂ andÂ pressÂ BÂ thenÂ C.
BEGIN…END block highlighting
When you place your cursor over a BEGIN or END keyword,Â SQL Prompt now automatically highlights the matching keyword:
RenameÂ variablesÂ and aliases
You can now use SQL Prompt toÂ rename all occurrences of a variable or alias in a query.
To rename a variable or alias, place your cursor over an instance of the variable or alias you want to rename and pressÂ F2:
Improved loading dialog box
The database loading dialog box now shows actual progress, and you can cancel loading databases:
Single suggestion improvement
SQL Prompt no longer suggests keywords if the keyword has been typed and no other suggestions exist.
SQL Prompt now has less impact on Management Studio start up time.