Latest stable build of SQL Prompt is 7.4.1 (16th February)

Michael Clark

Download

SQL Prompt 7.4.1 installer - Full release notes

Changes

This build of SQL Prompt includes:

• Support for SQL Server Management Studio 17
• Formatting improvements:
  • Improvements to begin/end formatting
  • Improvements to nested parentheses
  • Case statements with comments now align correctly
  • Now adds a space before aliases following function calls (forum)
  • Added "Place BEGIN keyword on new line" option. You can use this to keep BEGIN on the same line as IF, for example:

    IF @BusinessEntityID > 0 BEGIN
        DELETE FROM HumanResources.Employee_Temporal
        WHERE BusinessEntityID = @BusinessEntityID;
    END
    

• Azure support:
  • Visual Studio Azure connection support
  • Azure active directory universal authentication support
• Fixes:
  • Fix problem with Add/remove AS keyword in MERGE statements
  • Fix window functions and GROUP BY suggestions (forum)
  • SQL Prompt now always escapes an alias if it's a keyword (forum)
  • Columns are no longer qualified inside their own table definition (forum)
  • Add/remove square brackets no longer adds brackets to customizable event attributes (forum)
  • SQL Prompt no longer expands wildcards for ambiguous column lists (forum)
  • Fix performance issue with licensing (forum)
  • SP-6079 Intellisense showing blank values for table aliases (forum)

Feedback

If you find any issues with this release, please post them on this forum.

If you have any suggestions for improvements, please post them on our suggestions forum so other users can vote for them.