These pages cover SQL Prompt versions 6.0 to 6.3. Help for older versions is also available.

Skip to end of metadata
Go to start of metadata

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.

Insert semicolons

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:

Icon

If you want to change the highlight color, you can use the Management Studio functionality for customizing colors.

In Management Studio, go to Tools > Options > Environment > Fonts and Colors and select a new color for Brace Matching (Rectangle):

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.

Performance improvement

SQL Prompt now has less impact on Management Studio startup time.

Bug fixes

SP-2370Aliases with the same names as existing database objects are now recognized as aliases
SP-2705Prompt no longer suggests wrong columns for aliases with the same names as existing table
SP-2730UPDATE statement table aliases now resolve correctly
SP-4188Correct suggestions are now displayed before a CASE statement
SP-4443Fixed some situations where the suggestions pop-up didn't display properly
 Views from INFORMATION_SCHEMA are no longer qualified with master
  • No labels