NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.1

SQL Pretty Printer V3.3.1 is available on June 12, 2012.

You can download the latest version here:

Desktop version: http://www.dpriver.com/dl/sqlpp_desktop_3_3_1.zip

Add-In for SSMS: http://www.dpriver.com/dl/ppforssms_3_3_1.zip

Add-In for Visual Studio: http://www.dpriver.com/dl/ppforvs_3_3_1.zip

We have added some new format options to make this sql formatter tool more flexible to generate sql layout that you need.

1. gFmtOpt.Parameters_align_datatype, align data type in parameters of create function/procedure. this option also apply to declare variable/table and create table fields.

2. gFmtOpt.Select_FromclauseJoinConditionInNewline, put join condition into new line.

3. gFmtOpt.update_set_clause_inNewLine, update statement set clause into a new line, gFmtOpt.update_from_clause_inNewLine, update statement from clause into a new line

4. gFmtOpt.case_builtinfunc, able to set case of built-in function(sql server only in current version).

5. [DB2] able to support begin…end block syntax.

6. [Oracle] support model clause.

7. [Oracle] support siblings keyword of order by clauses.

8. [Oracle] support use of an IN keyword followed by a string literal like source_entity_cd IN ‘D7’

9. [Oracle] A fully-qualified column of the inline view can be used in IN condition

10. [sql server] support SQLCMD variable

11. [Oracle] able to parse the Package Declaration and Package Body is written in the same file

12. [DB2] support CTE query in create view statement.
[Oracle] support multi table insert.

You can download the latest version here:

Desktop version: http://www.dpriver.com/dl/sqlpp_desktop_3_3_1.zip

Add-In for SSMS: http://www.dpriver.com/dl/ppforssms_3_3_1.zip

Add-In for Visual Studio: http://www.dpriver.com/dl/ppforvs_3_3_1.zip