SQL Prompt 8

SQL Prompt 8.2 release notes

8.2.5.2924 - November 1st 2017

Fixes 

  • Only tabs indentation setting uses tabs in more places

  • SP-6647 : Fix DELETE table alias not vertically aligned

  • SP-6662 : Fix incorrect alignment in CREATE TABLE statement

  • SP-6354 : Fix IIF statements issue with subqueries

  • SP-6656 : Fix missing styles on load

8.2.4.2825 - October 25th 2017

Fixes 

  • SP-6576 : DECLARE AS TABLE statement not formatting correctly.

  • SP-6637 : Bug with table variable with constraints.

  • SP-6641 : WITH RESULT SETS formats parenthesis inconsistently.

  • SP-6648 : CREATE FUNCTION does not respect alignment options.

8.2.3.2750 - October 18th 2017

Fixes 

  • SP-6651 : Fix truncate table statement formatting 

8.2.2.2657 - October 11th 2017

Fixes

  • SP-6643 : Fixed parser's "Undefined: [ABORT]" crash.
  • SP-6646 : UPDATE/DELETE join table alignment no longer causes "Value cannot be null" failures on format.

 

8.2.1.2603 - October 04th 2017

Features

  • Added support for most new SQL Server 2017 syntax, including:
    • Add support for new Graph Table syntax.
    • New SET IDENTITY_CACHE option for ALTER DATABASE SCOPED CONFIGURATION.
    • New syntax for online resumable ALTER INDEX statements.
    • Add support for new SELECT INTO .. ON Filegroup syntax.

Fixes

  • SP-6617 : Fix 'Align items across clauses' option not aligning to JOIN tables.
  • SP-6626 : Fix AS keywords not aligning in DECLARE statements if 'Align data types' option is set.
  • SP-6627 : Fix multiple INSERT INTO ... EXECUTE formatting bugs with linked servers.

8.2.0.2504 - September 27th 2017

Features

  • Added new INSERTS page with formatting options for both the column and values lists.

 

image

Fixes

    • SP-6598 : COALESCE does not use the same formatting as functions.
    • SP-6606 : Add support for inline filtered indexes.
    • SP-6608 : Fix synonymns not being suggested as a merge target.
    • SP-6612 : Fix column alias style refactoring sometimes incorrectly applying to the inside of a CAST or PARSE function.
    • SP-6616 : Fix formatting for ALTER EVENT SESSION statements with extended events failing.
    • SP-6618 : Fix JOIN statements in a MERGE failing to format.
    • SP-6619 : Fix UniversalAccessTokenCache spamming log files

Didn't find what you were looking for?