SQL Prompt 7.4 beta

Harry Frankish · February 3, 2017 8:52AM

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 &gt; 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

SQL Prompt 7.4 beta

Product Learning

Community Forums

Events & Friends

Simple Talk