SQL Formatter Option: Subquery newline after EXISTS keyword

This format option control whether put a blank line after EXISTS keyword when there is a subquery follows. name: Subquery_Newline_After_EXISTS, default is false setting path: subquery -> Linebreak after EXISTS keyword SELECT TOP 1 CASE                WHEN CASE                       WHEN NOT EXISTS (SELECT [lpa_l1].[Categoryid]                                        FROM   (SELECT p.[Categoryid] AS [categoryid],                                                       p.[Discontinued],                                                       p.[Unitsonorder]                                                FROM   [northwind].[dbo].[PRODUCTS] p                                                WHERE  (( p.[Categoryid] = @p1 ))) [lpa_l1]) THEN 1                       ELSE 0…

SQL Formatter Option: Subquery newline after IN keyword

This format option control whether put a blank line after IN keyword when there is a subquery follows. name: Subquery_Newline_After_IN, default is false setting path: subquery -> Linebreak after IN keyword SELECT od.[Discount],        od.[Quantity],        od.[Unitprice] FROM   [northwind].[dbo].[ORDER DETAILS] AS od WHERE  ( od.[Orderid] IN (SELECT o.[Orderid] AS [orderid]                           FROM   [northwind].[dbo].[ORDERS] o                           WHERE  (( o.[Customerid] IN (SELECT c.[Customerid] AS [customerid]                                                        FROM   [northwind].[dbo].[CUSTOMERS] c) ))) )  After…

New SQL format options in Ver3.2.0

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,…