SQL Pretty Printer 3.6.0 released

Februar 19, 2016
Patch-Veröffentlichung

SQL Pretty Printer is a SQL formatter tool that helps beautify your SQL code. Using hotkey functionality, SQL Pretty Printer can reformat SQL statements for a wide variety of tools including Microsoft Query Analyzer, SQL Server Management Studio (SSMS), TOAD, PL/SQL Developer, Visual Studio, Eclipse, UltraEditor and EditPlus. In addition to beautifying SQL code, SQL Pretty Printer can translate SQL code into C#, Java, PHP, Delphi and other programing languages.

Updates in 3.6.0

  • [sql formatter] Fixed case expression in a plus expression formatting bug.
  • [SQL server] Supports try_parse() function.
  • [sql formatter] Added new format option gfmtopt.onlyinsertblankaftergo to support: BLANK LINES only after "GO" statements.
  • [sql formatter] New option gfmtopt.CTE_StackColumnList to stack column list in CTE.
  • [SQL Server] Supports set clause in alter table statement.
  • [Oracle] Fixed can't parse syntax like: v_return_value.year in plsql.
  • [Oracle] Fixed can't parse query when "log" used as table or column name.
  • [SQL Server] Supports TRY_CAST function.
  • [SQL Server] Supports parse function.
  • [SQL Server] Fixed a bug where XML can't be a column name.
  • [Oracle] Supports enabling the validate clause in alter table statement.
  • [SQL Server] Supports altering index statement by adding TAlterIndexSqlStatement.
  • [Oracle] Supports interval value in analytic function.
  • [Oracle] Enables parse pivot/unpivot clause. Full parse tree is still not available.
  • [SQL Server] Fixed can't parse begin try/end catch statement if there is no statement inside catch block.
  • [SQL Server] Fixed can't parse begin try/end catch statement when it's the only statement in a stored procedure.
  • [SQL Server] Supports CLOSE SYMMETRIC KEY.
  • [MySQL] Supports delimiter command.
  • [Oracle] Fixed can't parse sort clause in XMLAGG function.
  • [format option] Added new option: analyticFunctionInNewline, default is true.
  • [SQL Server] Supports offset/fetch clause in order by clause.

About Gudu Software

Gudu Software is a privately held software company focusing on providing database tools. Founded in 2002, Gudu Software has developed 5 products. With more than 800 customers in over 30 countries worldwide, Gudu Software continue to provide useful tools for SQL developers at a reasonable price, and focus investments on product development and customer support.

Before and after views of SQL code in SQL Pretty Printer.

Sie haben eine Frage?

Live-Chat mit unseren Gudu Software-Lizenzierungs-Spezialisten.