These pages cover SQL Prompt 7, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

March 26th, 2015

Tab coloring

You can now:

  • customize the environments and colors:
  • color tabs based on the server and/or database
  • view colored servers/databases on a page in the Options dialog box:
  • view environment colors by right-clicking tabs, or by right-clicking servers or databases in the Object Explorer and the Registered Servers windows 
  • color server groups by right-clicking the group in the Registered Servers window

There are also some behavior changes:

  • tabs and windows remain colored even if a query is undocked
  • non-query windows are now colored (eg the table designer)

For more information, see Coloring query tabs.

GROUP BY and ORDER BY

The GROUP BY suggestions list now shows non-aggregated columns and expressions at the start. It also now contains the suggestion All non-aggregated columns, which expands to all the non-aggregated columns and expressions:


The ORDER BY suggestions list now shows DESC and ASC at the top:


Import/export all options

You can now import and export all your SQL Prompt options using the buttons at the bottom of the Options dialog box:

SQLCMD mode support

SQL Prompt now supports SQLCMD mode:

  • SQLCMD variables resolve to their base objects
  • You can format SQLCMD scripts, and other SQL Prompt features also work with SQLCMD
  • SQL Prompt suggests local, environment, and VisualStudio SQLCMD variables
  • You can rename SQLCMD variables by pressing F2 (see Renaming scripted objects)
  • You can use :r and :out to open a browse dialog box

Format actions

You can now choose what will happen when you run Format SQL by going to Format > Actions in the Options dialog box:

 You can now run Format SQL to add square brackets to all identifiers.

Format SQL now inserts semicolons by default.

Other improvements

  • You can now close all tabs that haven't changed since they were opened by right-clicking a tab and clicking Close All Unmodified:
     
  • When you write cross-database queries, the suggestions list now shows database objects as well as schemas: 

    If you select an object, SQL Prompt auto-completes the schema.
  • SQL Prompt no longer swallows closing parentheses unless they're superfluous
  • You can now rename temporary tables and columns within them by pressing F2 (see Renaming scripted objects)
  • SQL Prompt now shows useful keywords at the top of suggestions lists. For example, SELECT is shown above SAVE
  • SQL Prompt now suggests new syntax when connected to Azure SQL Database v12 databases
  • No labels