SQL Pretty Printer Releases

Released: Apr 4, 2024

Updates in v4.0.2

Features

  • Added support for SQL Server Management Studio (SSMS) 2020 (20.0).
  • Added support for Microsoft Visual Studio 2022.

Released: Feb 27, 2023

Updates in SQL Pretty Printer

Features

  • Added support for Microsoft SQL Server Management Studio (SSMS) 2019 (19.0).

Released: Jun 5, 2019

Updates in v4.0.1

Features

  • Added support for Visual Studio 2019.
  • Added support for SQL Server Management Studio (SSMS) 2017 (18.0).

Released: May 4, 2018

Updates in v3.9.0

Features

  • SQL Pretty Printer Add-In for SSMS adds support for Microsoft SQL Server Management Studio 2017.

Released: Jul 7, 2016

Updates in v3.8.1

Features

  • SQL Pretty Printer Add-In for SSMS adds support for SQL Server Management Studio 2016.

Released: Feb 19, 2016

Updates in this release

Updates in v3.6.0

  • [sql formatter] fix a bug can't format case expression in a plus expression.
  • [sql server] support try_parse() function.
  • [sql formatter] add new format option gfmtopt.onlyinsertblankaftergo to support: BLANK LINES only after "GO" statements this option works only gfmtopt.insertblanklineinbatchsqls is true.
  • [sql formatter] new option option: gfmtopt.CTE_StackColumnList to stack column list in CTE.
  • [SQL Server] support set clause in alter table statement.
  • [Oracle] fix a bug can't...

Released: May 8, 2015

Updates in this release

Updates in v3.5.2

  • [sql formatter] Access Violation while set expr_remove_redundant_brackets = true.
  • [sql server] Exec statement after set rowcount doens't format correctly.

Released: May 4, 2015

Updates in this release

Updates in v3.5.1

  • [sql formatter] fix a bug misalign column align if column including a function.
  • [format option] add new format option: encloseIdentifierWithBrackets, enclose all identifiers with brackets when it's true. (Add-In version: Format options->Default Options )

Released: Mar 13, 2015

Updates in this release

Updates in v3.5.0

  • support new databases: informix, postgresql, sybase,Teradata.
  • [sql formatter] stack on parameters on a FETCH NEXT cursor if parameter number more than 5.
  • [sql formatter] fix a bug that remove linebreak between sql statements while set ouput to "keep layout"
  • [format options] wordSeparator, if this option was set, use this token to separate word in variable/identifier/name. this option works when CaseOption = coInitCapEachWord. if gfmtopt.wordSeparator = '-', take identifier: dec...

Released: Nov 11, 2014

Updates in this release

Updates in 3.4.6

  • Added commaInsideList, AlignJoinCondition, CTEComma, Createtable_fields_alignWithCreateKeyword new format options.
  • Fixed bug with align operator.
  • Fixed bug generating SQL incorrectly if Order By clause appears after Update clause.
  • Support for XMLTABLE clause.
  • Converting SQL to other languages doesn't change layout or case.