New release: SQL Pretty Printer Version 3.2.0

In this new version, we have introduced some awesome new features, and make it more easy to use by redesign format option panel.

This version had better support for New T-SQL features introduced in SQL Server 2008.

Download SQL Pretty Printer V3.2 (size 5M)

• SQL Refactor: rename table and column
• Introduce 9 new format options
• Redesign format option panel, Much more convenience to set format options, easy to see the effect of an option. Able to see effect of an option in main editor without close the the format option window.
• New SQL syntax support
  • [SQL Server]
    • support Sparse Columns of sql server 2008.
    • support SQL Server 2008 new introduced several extensions to the GROUP BY clause:
      GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function.
    • support delete in merge not matched clause
    • support sql server 2008 HIERARCHYID Data Type
    • support Compound Assignment Operators
    • support the geometry and geography feature of SQL Server 2008
    • fix bug that can’t process empty block in SQL Server
    • support SQL Server kill statement
    • support READONLY keyword in variable declare.
  • [Oracle]
    • support oracle XMLQUERY sytnax
    • \ is not a escape char of oracle string literal
    • SUBTYPE keyword can be qualified name in plsql.
    • column datatype can’t be empty in create table statement.
    • default/null keyword can’t be a datatype name.
    • support connect_by_root unary operator.
    • able to detect select syntax error in cursor declare of plsql.
    • support mod in plsql
  • [MS ACCESS]
    support string like this: #4/1/2008 3:09:29 PM#
• Misc
  • Recheck all keywords of Oracle, SQL Server, DB2 and MySQL.
  • control format of condition expression in case expression.
  • improve formatting of case expression
  • < character in html output not processed correctly
  • RTF output support korean, chinese and other multi-byte characters.
  • in sql formatter ugly mode, when convert to single line, remove extra spaces in output sql
  • support ; before WITH keyword in CTE
  • fix bug that remove space around DEFAULT keyword in following sql when WSPadding_OperatorArithmetic is false.
    PROCEDURE report_create (v_ts IN DATE, p_msg IN VARCHAR2,p_file_mode IN VARCHAR2 DEFAULT ‘A’);

Download SQL Pretty Printer V3.2 (size 5M)