SQL Prompt 7.4 beta

Harry Frankish

Download SQL Prompt 7.4 beta

This build of SQL Prompt includes:

• Support for SQL Server Management Studio 17
• Formatting improvements:
  • 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)

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.

7.4.1.564 - 14th February

• Improvements to begin/end formatting
• SP-6079 Intellisense showing blank values for table aliases

7.4.0.471 - 3rd February

• Initial release