{"id":620,"date":"2010-11-29T22:35:38","date_gmt":"2010-11-30T03:35:38","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=620"},"modified":"2011-09-27T03:55:22","modified_gmt":"2011-09-27T08:55:22","slug":"new-sql-format-options-in-ver3-2-0","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/11\/new-sql-format-options-in-ver3-2-0\/","title":{"rendered":"New SQL format options in Ver3.2.0"},"content":{"rendered":"

We have introduced 9 new format options in SQL Pretty Printer version 3.2.0.<\/p>\n

1. IntoClauseInNewline<\/strong><\/p>\n

<\/p>\n

when IntoClauseInNewline is false<\/p>\n

<\/p>\n

when IntoClauseInNewline is true<\/p>\n

<\/p>\n

2. WhereClauseInNewline, LinefeedsAndOr_option<\/strong><\/p>\n

<\/p>\n

when WhereClauseInNewline is false<\/p>\n

<\/p>\n

when WhereClauseInNewline is true<\/p>\n

<\/p>\n

position of AND\/OR keyword and newline, when AND\/OR keyword is in the end of line:<\/p>\n

<\/p>\n

position of AND\/OR keyword and newline, when AND\/OR keyword is at the same line:<\/p>\n

<\/p>\n

3. GroupByClauseInNewline, Select_Groupby_Style<\/strong><\/p>\n

<\/p>\n

when GroupByClauseInNewlineis false<\/p>\n

<\/p>\n

when GroupByClauseInNewlineis true<\/p>\n

<\/p>\n

when group by column list style is wrapped.<\/p>\n

<\/p>\n

4. OrderByClauseInNewline, Select_Orderby_Style<\/strong><\/p>\n

<\/p>\n

when OrderByClauseInNewline is false<\/p>\n

<\/p>\n

when OrderByClauseInNewline is true<\/p>\n

<\/p>\n

when order by column list style is wrapped.<\/p>\n

<\/p>\n

5. HavingClauseInNewline<\/strong><\/p>\n

<\/p>\n

when HavingClauseInNewline is false<\/p>\n

<\/p>\n

when HavingClauseInNewline is true<\/p>\n

<\/p>\n

6. Update_Columnlist_Style<\/strong><\/p>\n

when Update_Columnlist_Style is stacked<\/p>\n

<\/p>\n

when Update_Columnlist_Style is wrapped<\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

We have introduced 9 new format options in SQL Pretty Printer version 3.2.0. 1. IntoClauseInNewline when IntoClauseInNewline is false when IntoClauseInNewline is true 2. WhereClauseInNewline, LinefeedsAndOr_option when WhereClauseInNewline is false when WhereClauseInNewline is true position of AND\/OR keyword and newline, when AND\/OR keyword is in the end of line: position of AND\/OR keyword and newline, when AND\/OR keyword is at the same line: 3. GroupByClauseInNewline, Select_Groupby_Style when GroupByClauseInNewlineis false when GroupByClauseInNewlineis true when group by column list style is wrapped. 4. OrderByClauseInNewline, Select_Orderby_Style when OrderByClauseInNewline is false when OrderByClauseInNewline is true when order by column list style is wrapped. 5.\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 SQL format options in Ver3.2.0<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n