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.