{"id":107,"date":"2010-03-01T23:43:11","date_gmt":"2010-03-02T04:43:11","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=107"},"modified":"2011-09-26T21:49:38","modified_gmt":"2011-09-27T02:49:38","slug":"new-release-sql-pretty-printer-3-1-0","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/03\/new-release-sql-pretty-printer-3-1-0\/","title":{"rendered":"New release: SQL Pretty Printer 3.1.0"},"content":{"rendered":"

Hello everyone!
\nIt\u2019s been three months since our last release(v3.0.7), and it feels much longer for some reason. We\u2019ve been really busy.<\/p>\n

How have you been? We missed you! \ud83d\ude42<\/p>\n

We have some nice updates for you today.<\/p>\n

Portable version<\/strong><\/p>\n

SQL Pretty Printer desktop version now is a portable software(also known as portable application<\/em>), It is suitable for use on portable drives such as a USB (thumb) drive. You can carry SQL Pretty Printer on a portable drive for use on any computer. Application Settings and format options are stored with, and can be carried around with SQL Pretty Printer,\u00a0 Leaves a zero “footprint” on any PC it’s run on after being used.<\/p>\n

It’s quite easy to create a portable version after install SQL Pretty Printer on your computer,\u00a0 Just click menu item from Help->Create portable version, and then start SQL Pretty Printer from directory where portable version was created.<\/p>\n

\"Portable
Portable Version<\/figcaption><\/figure>\n

Better support for multiline comments, all lines in the comment block to be left-aligned with the indented code below the comments.<\/strong><\/p>\n

\"SQL
SQL multi lines comment formatting<\/figcaption><\/figure>\n


\n<\/strong><\/p>\n

New layout options to control empty lines between consecutive set\/declare statements<\/strong><\/p>\n

\"consecutive
consecutive declares\/set statement empty lines<\/figcaption><\/figure>\n

New layout options for function call parameters.<\/strong><\/p>\n

\"Align
Align parameters in function call<\/figcaption><\/figure>\n

Able to add\u00a0 user customized keyword<\/strong>s or non-keywords<\/strong><\/p>\n

\"Customized
Customized SQL keywords<\/figcaption><\/figure>\n

if a keyword was also a function name, then it was processed as a\u00a0 keyword by SQL Pretty Printer.<\/p>\n

CASE SENSITIVE in some SQL Server SQL statements.<\/strong><\/p>\n

Because the default setting for SQL Pretty Printer before V3.0.7 was to change all identifier to lower case. This may broke all of the SQL openxml statements since the case of the columns in the schema portion of the statement must match the input xml blob casing.<\/p>\n

Obviously, resolving this issue was just a matter of going into the configuration template for SQL Pretty Printer and setting the configuration option of identifiers to preserve original casing.<\/p>\n

We change default case setting for identifier to lower case in this version.<\/strong><\/em><\/p>\n

Xml method query(),value(),exist(),modify(),nodes() keep lowercase no matter what case option was chosen for function case options.<\/p>\n

Oracle SQL dialect syntax support enhanced<\/strong><\/p>\n