{"id":1364,"date":"2012-05-04T02:04:14","date_gmt":"2012-05-04T07:04:14","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1364"},"modified":"2012-05-04T02:09:33","modified_gmt":"2012-05-04T07:09:33","slug":"new-release-sql-pretty-printer-version-3-3-0","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/","title":{"rendered":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0"},"content":{"rendered":"

We are pleased to let you know that SQL Pretty Printer V3.3.0 is available on May 4, 2012. This version begin to support MDX formatting. Add 12 new format options, now there are more than one hundred format options<\/a> make sql pretty printer more flexible to achieve SQL layout you need.<\/p>\n

Download SQL Pretty Printer:<\/p>\n

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

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

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

1. support MDX formatting.<\/p>\n

<\/p>\n

2. new format option:gfmtopt.AlignAndOrWithOnInJoinClause, able to align AND\/OR keywords with ON in join clause.<\/p>\n

<\/p>\n

3. new format option:gfmtopt.expr_concat_string_max_length, format string concat expression into a more readable format.<\/p>\n

<\/p>\n

4. new format options:\tgfmtopt.CaseWhenInSamelineAsCase, gfmtopt.CaseThenExprInNewline,gfmtopt.CaseElseExprInNewline, able to set case expression into a new layout. <\/p>\n

<\/p>\n

5. new format options: gfmtopt.BEStyle_createtable_leftBEIndentSize, \tgfmtopt.BEStyle_createtable_rightBEIndentSize,gfmtopt.Createtable_Fieldlist_Comma_option, gfmtopt.Createtable_Fieldlist_Style. Control layout for create table in a more flexible way, these format options apply to declare table as well.<\/p>\n

<\/p>\n

6. new format option: gfmtopt.Insert_Columns_Per_line.\tThis format option make it much more easy to link value to column in insert statement.
\nif there is a subquery in insert statement, select list also effected by this option no matter what’s value of Select_Columnlist_Style was set.<\/p>\n

<\/p>\n

7. new format options: gfmtopt.WhereClauseAlignExpr, align expression in where clause.<\/p>\n

<\/p>\n

8. new format options: gFmtOpt.AlignAliasInFromClause, align table alias in from clause.<\/p>\n

<\/p>\n

9. format privot table in a more readable layout<\/p>\n

<\/p>\n

10. format AnalyticFunction in a more readable layout.<\/p>\n

<\/p>\n

11. better support of –begin_no_format, –end_no_format tag to preserve original sql layout.<\/p>\n

12. Improve internal parser to support more SQL syntax of different databases.<\/p>\n

Download SQL Pretty Printer:<\/p>\n

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

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

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

We are pleased to let you know that SQL Pretty Printer V3.3.0 is available on May 4, 2012. This version begin to support MDX formatting. Add 12 new format options, now there are more than one hundred format options make sql pretty printer more flexible to achieve SQL layout you need. Download SQL Pretty Printer: Desktop version: http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_v3_3_0.zip Add-In for SSMS: http:\/\/www.dpriver.com\/dl\/ppforssms_3_3_0.zip Add-In for Visual Studio: http:\/\/www.dpriver.com\/dl\/ppforvs_3_3_0.zip 1. support MDX formatting. 2. new format option:gfmtopt.AlignAndOrWithOnInJoinClause, able to align AND\/OR keywords with ON in join clause. 3. new format option:gfmtopt.expr_concat_string_max_length, format string concat expression into a more readable format. 4. new\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.0<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n