06 June 2014

New features in SQL Prompt 6.4

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!

New features

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:

prompt1.png

When you press Shift + F5, only the second statement is executed:

 

prompt2.png

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.

prompt3.png

BEGIN…END block highlighting

When you place your cursor over a BEGIN or END keyword, SQL Prompt now automatically highlights the matching keyword:

prompt4.png

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:

prompt6.png

Improved loading dialog box

The database loading dialog box now shows actual progress, and you can cancel loading databases:

 

prompt5.png

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 start up time.

What do you think?

We want to hear your feedback about the beta. If you have any suggestions, or bugs to report, tell us on the SQL Prompt forum or our suggestions forum.

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

This post has been viewed 5568 times – thanks for reading.

  • Rate
    [Total: 0    Average: 0/5]
  • Share