{"id":683,"date":"2010-12-01T04:03:17","date_gmt":"2010-12-01T09:03:17","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=683"},"modified":"2011-09-26T21:36:37","modified_gmt":"2011-09-27T02:36:37","slug":"new-release-sql-pretty-printer-version-3-2-0","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/12\/new-release-sql-pretty-printer-version-3-2-0\/","title":{"rendered":"New release: SQL Pretty Printer Version 3.2.0"},"content":{"rendered":"

In this new version, we have introduced some awesome new features, and make it more easy to use by redesign format option panel. <\/p>\n

This version had better support for New T-SQL features introduced in SQL Server 2008.<\/p>\n

Download SQL Pretty Printer V3.2 (size 5M) <\/a><\/p>\n

\n
- SQL Refactor: rename table and column<\/a><\/li>\n
- Introduce 9 new format options<\/a><\/li>\n
- Redesign format option panel<\/a>, Much more convenience to set format options, easy to see the effect of an option. Able to see effect of an option in main editor without close the the format option window.<\/li>\n
- New SQL syntax support\n
  \n
  - \n\t[SQL Server]<\/p>\n
    \n
    - \n\t\t\t\tsupport Sparse Columns of sql server 2008.\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport SQL Server 2008 new introduced several extensions to the GROUP BY clause:
      \n\t\t\t\t\tGROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and the GROUPING_ID function.\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport delete in merge not matched clause\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport sql server 2008 HIERARCHYID Data Type\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport Compound Assignment Operators\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport the geometry and geography feature of SQL Server 2008\n\t\t\t<\/li>\n
    - \n\t\t\t\tfix bug that can’t process empty block in SQL Server\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport SQL Server kill statement\n\t\t\t<\/li>\n
    - \n\t\t\t\tsupport READONLY keyword in variable declare.\n\t\t\t<\/li>\n<\/ul>\n<\/li>\n
    - \n\t[Oracle]<\/p>\n
      \n
      - \n\t\tsupport oracle XMLQUERY sytnax\n\t\t\t<\/li>\n
      - \n\t\t\\ is not a escape char of oracle string literal\n\t\t\t<\/li>\n
      - \n\t\tSUBTYPE keyword can be qualified name in plsql.\n\t\t\t<\/li>\n
      - \n\t\tcolumn datatype can’t be empty in create table statement.\n\t\t\t<\/li>\n
      - \n\t\tdefault\/null keyword can’t be a datatype name.\n\t\t\t<\/li>\n
      - \n\t\tsupport connect_by_root unary operator.\n\t\t\t<\/li>\n
      - \n\t\table to detect select syntax error in cursor declare of plsql.\n\t\t\t<\/li>\n
      - \n\t\tsupport mod in plsql\n\t\t\t<\/li>\n<\/ul>\n<\/li>\n
      - \n\t[MS ACCESS]<\/p>\n
        \n\t\tsupport string like this: #4\/1\/2008 3:09:29 PM#\n\t\t<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
        - \nMisc<\/p>\n
          \n
          - \n\tRecheck all keywords of Oracle, SQL Server, DB2 and MySQL.\n\t\t\t<\/li>\n
          - \n\tcontrol format of condition expression in case expression.\n\t\t\t<\/li>\n
          - \n\timprove formatting of case expression\n\t\t\t<\/li>\n
          - \n\t< character in html output not processed correctly\n\t\t\t<\/li>\n
          - \n\tRTF output support korean, chinese and other multi-byte characters.\n\t\t\t<\/li>\n
          - \n\tin sql formatter ugly mode, when convert to single line, remove extra spaces in output sql\n\t\t\t<\/li>\n
          - \n\tsupport ; before WITH keyword in CTE\n\t\t\t<\/li>\n
          - \n\tfix bug that remove space around DEFAULT keyword in following sql when WSPadding_OperatorArithmetic is false.
            \n\t\tPROCEDURE report_create (v_ts IN DATE, p_msg IN VARCHAR2,p_file_mode IN VARCHAR2 DEFAULT ‘A’);\n\t\t\t<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            Download SQL Pretty Printer V3.2 (size 5M) <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

            In this new version, we have introduced some awesome new features, and make it more easy to use by redesign format option panel. This version had better support for New T-SQL features introduced in SQL Server 2008. Download SQL Pretty Printer V3.2 (size 5M) SQL Refactor: rename table and column Introduce 9 new format options Redesign format option panel, Much more convenience to set format options, easy to see the effect of an option. Able to see effect of an option in main editor without close the the format option window. New SQL syntax support [SQL Server] support Sparse Columns\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.0<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n