Click here to monitor SSC

New features in SQL Prompt 6.4

Published 6 June 2014 1:59 pm

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

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

 

prompt2

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

BEGIN…END block highlighting

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

prompt4

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

Improved loading dialog box

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

 

prompt5

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.

One Response to “New features in SQL Prompt 6.4”

  1. rjpaulsen says:

    I’m looking forward to the improvement in startup time. Between SQL prompt and SQL search, ssms crawls at startup. I love the product and its worth that wait, but it is noticeable and any improvement will be welcome.

Leave a Reply