{"id":940,"date":"2011-04-28T03:21:07","date_gmt":"2011-04-28T08:21:07","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=940"},"modified":"2011-09-27T03:47:22","modified_gmt":"2011-09-27T08:47:22","slug":"new-release-sql-pretty-printer-version-3-2-7","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/04\/new-release-sql-pretty-printer-version-3-2-7\/","title":{"rendered":"New release: SQL Pretty Printer Version 3.2.7"},"content":{"rendered":"

Hi All, we have introduced some new features since version 3.2.5, Here is the list for you:<\/p>\n

Download this new release:<\/p>\n

http:\/\/www.dpriver.com\/dl\/ppforssms_v327.zip<\/a><\/p>\n

http:\/\/www.dpriver.com\/dl\/ppforvs_v327.zip<\/a><\/p>\n

http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_v327.zip<\/a><\/p>\n

\n
- Add-in for SSMS supports Microsoft SQL Server Management Studio 11(SQL Denali) now<\/li>\n
- Add a new format option: gfmtopt.Insert_Indent_Select, able to indent the SELECT statement following an INSERT INTO
  \n
  <\/li>\n
- Better formatting for nested if else statement
  \n
  \n
  refined format:
  \n
  \n<\/li>\n
- Better formatting for RAISERROR statement<\/li>\n
- Able to format case expression inside convert function<\/li>\n
- Able to indent Begin \/ End in Trigger Statement by setting gfmtopt.BEStyle_Block_leftBEIndentSize
  \n
  <\/li>\n
- Fix a bug that SQL Pretty Printer desktop version does not pick customized keywords up after starting the app<\/li>\n
- Fix a Access violation error while formatting this SQL: ; WITH CTE AS (SELECT ‘1’ As Something)SELECT * FROM CTE;<\/li>\n
- Fix a bug that even \u201cGroup by Clause in New Line\u201d checked,
  \nthe formatted code still has the \u201cGROUP BY\u201d and the first group item on the same line, this occurs only there is one group item.<\/li>\n
- Able to format Micorsoft Access statement: transform, parameters<\/li>\n
- Lots of minor bugs fixed<\/li>\n<\/ul>\n

  Download this new release:<\/p>\n

  http:\/\/www.dpriver.com\/dl\/ppforssms_v327.zip<\/a><\/p>\n

  http:\/\/www.dpriver.com\/dl\/ppforvs_v327.zip<\/a><\/p>\n

  http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_v327.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

  Hi All, we have introduced some new features since version 3.2.5, Here is the list for you: Download this new release: http:\/\/www.dpriver.com\/dl\/ppforssms_v327.zip http:\/\/www.dpriver.com\/dl\/ppforvs_v327.zip http:\/\/www.dpriver.com\/dl\/sqlpp_desktop_v327.zip Add-in for SSMS supports Microsoft SQL Server Management Studio 11(SQL Denali) now Add a new format option: gfmtopt.Insert_Indent_Select, able to indent the SELECT statement following an INSERT INTO Better formatting for nested if else statement refined format: Better formatting for RAISERROR statement Able to format case expression inside convert function Able to indent Begin \/ End in Trigger Statement by setting gfmtopt.BEStyle_Block_leftBEIndentSize Fix a bug that SQL Pretty Printer desktop version does not pick customized keywords\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.2.7<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n