June 4th, 2014
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 also execute the current batch by pressing Alt + Shift + F5.
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:
Qualify object names improvements
The qualify object names feature now includes the following improvements:
- a new option for qualifying column names with aliases
- changes to the script are now highlighted
- errors are no longer displayed if temporary tables are created in the script
- the existing cache is now used rather than recaching some objects
- if the table has been aliased, table qualification is replaced with its alias
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 startup time.
|SP-2370||Aliases with the same names as existing database objects are now recognized as aliases|
|SP-2705||Prompt no longer suggests wrong columns for aliases with the same names as existing table|
|SP-2730||UPDATE statement table aliases now resolve correctly|
|SP-4188||Correct suggestions are now displayed before a CASE statement|
|SP-4443||Fixed some situations where the suggestions pop-up didn't display properly|
|Views from INFORMATION_SCHEMA are no longer qualified with master|