{"id":192,"date":"2010-05-28T04:31:38","date_gmt":"2010-05-28T09:31:38","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=192"},"modified":"2011-09-27T03:58:36","modified_gmt":"2011-09-27T08:58:36","slug":"new-release-sql-pretty-printer-3-1-2","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/","title":{"rendered":"New release: SQL Pretty Printer 3.1.2"},"content":{"rendered":"<p>Hello everyone!<\/p>\n<p>We have some improvements about this new update.<\/p>\n<ul>\n<li>\nSQL Server merge statement was supported.\n<\/li>\n<li>\nHtml output was checked as XHTML 1.0 Strict.\n<\/li>\n<li>\nSupport qualified name of pivot column.\n<\/li>\n<li>\nQualified data type was supported in SQL Server.\n<\/li>\n<li>\nWhen convert SQL to VB\/VB String Buffer, &#8221; was escaped correctly.\n<\/li>\n<li>\nOther minor bugs fixed.\n<\/li>\n<\/ul>\n<p>You can always download the latest version of\u00a0 SQL Pretty Printer here:<\/p>\n<p><a title=\"SQL Pretty Printer\" href=\"http:\/\/www.dpriver.com\/dlaction.php\">http:\/\/www.dpriver.com\/dlaction.php<\/a><\/p>\n<p>If\u00a0 you have any questions or comments about SQL Pretty Printer, feel free to contact me at support@dpriver.com<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello everyone! We have some improvements about this new update. SQL Server merge statement was supported. Html output was checked as XHTML 1.0 Strict. Support qualified name of pivot column. Qualified data type was supported in SQL Server. When convert SQL to VB\/VB String Buffer, &#8221; was escaped correctly. Other minor bugs fixed. You can always download the latest version of\u00a0 SQL Pretty Printer here: http:\/\/www.dpriver.com\/dlaction.php If\u00a0 you have any questions or comments about SQL Pretty Printer, feel free to contact me at support@dpriver.com<\/p>\n","protected":false},"author":2,"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":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New release: SQL Pretty Printer 3.1.2<\/title>\n<meta name=\"description\" content=\"New release: SQL Pretty Printer 3.1.2\" \/>\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\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\" \/>\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 3.1.2\" \/>\n<meta property=\"og:description\" content=\"New release: SQL Pretty Printer 3.1.2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-28T09:31:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-09-27T08:58:36+00:00\" \/>\n<meta name=\"author\" content=\"James\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James\" \/>\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\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\",\"name\":\"New release: SQL Pretty Printer 3.1.2\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2010-05-28T09:31:38+00:00\",\"dateModified\":\"2011-09-27T08:58:36+00:00\",\"description\":\"New release: SQL Pretty Printer 3.1.2\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New release: SQL Pretty Printer 3.1.2\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\"},\"author\":{\"name\":\"James\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04\"},\"headline\":\"New release: SQL Pretty Printer 3.1.2\",\"datePublished\":\"2010-05-28T09:31:38+00:00\",\"dateModified\":\"2011-09-27T08:58:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/\"},\"wordCount\":95,\"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\/7bbdbb6e79c5dd9747d08c59d5992b04\",\"name\":\"James\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g\",\"caption\":\"James\"},\"sameAs\":[\"http:\/\/www.dpriver.com\"],\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/james\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New release: SQL Pretty Printer 3.1.2","description":"New release: SQL Pretty Printer 3.1.2","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\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/","og_locale":"en_US","og_type":"article","og_title":"New release: SQL Pretty Printer 3.1.2","og_description":"New release: SQL Pretty Printer 3.1.2","og_url":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/","og_site_name":"SQL and Data Blog","article_published_time":"2010-05-28T09:31:38+00:00","article_modified_time":"2011-09-27T08:58:36+00:00","author":"James","twitter_card":"summary_large_image","twitter_misc":{"Written by":"James"},"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\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/","url":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/","name":"New release: SQL Pretty Printer 3.1.2","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2010-05-28T09:31:38+00:00","dateModified":"2011-09-27T08:58:36+00:00","description":"New release: SQL Pretty Printer 3.1.2","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"New release: SQL Pretty Printer 3.1.2"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/"},"author":{"name":"James","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/7bbdbb6e79c5dd9747d08c59d5992b04"},"headline":"New release: SQL Pretty Printer 3.1.2","datePublished":"2010-05-28T09:31:38+00:00","dateModified":"2011-09-27T08:58:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/05\/new-release-sql-pretty-printer-3-1-2\/"},"wordCount":95,"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\/7bbdbb6e79c5dd9747d08c59d5992b04","name":"James","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eeddf4ca7bdafa37ab025068efdc7302?s=96&d=mm&r=g","caption":"James"},"sameAs":["http:\/\/www.dpriver.com"],"url":"https:\/\/www.dpriver.com\/blog\/author\/james\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/192"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=192"}],"version-history":[{"count":7,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/192\/revisions"}],"predecessor-version":[{"id":1082,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/192\/revisions\/1082"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}