{"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

\"mdx<\/p>\n

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

\"select<\/p>\n

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

\"sql<\/p>\n

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

\"sql<\/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

\"sql<\/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

\"sql<\/p>\n

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

\"sql<\/p>\n

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

\"sql<\/p>\n

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

\"sql<\/p>\n

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

\"sql<\/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<meta name=\"description\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\" \/>\n<meta property=\"og:description\" content=\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-04T07:04:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-05-04T07:09:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dpriver.com\/images\/screenshots\/v330\/mdx-drillthrough.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\",\"name\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2012-05-04T07:04:14+00:00\",\"dateModified\":\"2012-05-04T07:09:33+00:00\",\"description\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0\",\"datePublished\":\"2012-05-04T07:04:14+00:00\",\"dateModified\":\"2012-05-04T07:09:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/\"},\"wordCount\":331,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"release\",\"sql pretty printer\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/","og_locale":"en_US","og_type":"article","og_title":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","og_description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","og_url":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/","og_site_name":"SQL and Data Blog","article_published_time":"2012-05-04T07:04:14+00:00","article_modified_time":"2012-05-04T07:09:33+00:00","og_image":[{"url":"http:\/\/www.dpriver.com\/images\/screenshots\/v330\/mdx-drillthrough.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/","url":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/","name":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2012-05-04T07:04:14+00:00","dateModified":"2012-05-04T07:09:33+00:00","description":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.0","datePublished":"2012-05-04T07:04:14+00:00","dateModified":"2012-05-04T07:09:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2012\/05\/new-release-sql-pretty-printer-version-3-3-0\/"},"wordCount":331,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["release","sql pretty printer"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1364"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=1364"}],"version-history":[{"count":28,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1364\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1364\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}