{"id":1396,"date":"2012-06-12T04:25:05","date_gmt":"2012-06-12T09:25:05","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1396"},"modified":"2012-06-12T04:25:05","modified_gmt":"2012-06-12T09:25:05","slug":"new-release-sql-pretty-printer-version-3-3-1","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2012\/06\/new-release-sql-pretty-printer-version-3-3-1\/","title":{"rendered":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.1"},"content":{"rendered":"

SQL Pretty Printer V3.3.1 is available on June 12, 2012. <\/p>\n

You can download the latest version here:<\/p>\n

Desktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_1.zip<\/a><\/p>\n

Add-In for SSMS: http:\/\/www.dpriver.com\/dl\/ppforssms_3_3_1.zip<\/a><\/p>\n

Add-In for Visual Studio: http:\/\/www.dpriver.com\/dl\/ppforvs_3_3_1.zip<\/a><\/p>\n

We have added some new format options to make this sql formatter tool more flexible to generate sql layout that you need.<\/p>\n

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.
\n<\/p>\n

2. gFmtOpt.Select_FromclauseJoinConditionInNewline, put join condition into new line.
\n<\/p>\n

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
\n<\/p>\n

4. gFmtOpt.case_builtinfunc, able to set case of built-in function(sql server only in current version).
\n<\/p>\n

5. [DB2] able to support begin…end block syntax. <\/p>\n

6. [Oracle] support model clause. <\/p>\n

7. [Oracle] support siblings keyword of order by clauses. <\/p>\n

8. [Oracle] support use of an IN keyword followed by a string literal like source_entity_cd IN ‘D7’ <\/p>\n

9. [Oracle] A fully-qualified column of the inline view can be used in IN condition <\/p>\n

10. [sql server] support SQLCMD variable <\/p>\n

11. [Oracle] able to parse the Package Declaration and Package Body is written in the same file <\/p>\n

12. [DB2] support CTE query in create view statement.
\n[Oracle] support multi table insert. <\/p>\n

You can download the latest version here:<\/p>\n

Desktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_3_3_1.zip<\/a><\/p>\n

Add-In for SSMS: http:\/\/www.dpriver.com\/dl\/ppforssms_3_3_1.zip<\/a><\/p>\n

Add-In for Visual Studio: http:\/\/www.dpriver.com\/dl\/ppforvs_3_3_1.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,24],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nNEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.1<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n