Category format option

This format option control whether put a blank line before comparison operator when it follows a subquery. name: Subquery_Newline_Before_ComparisonOperator, default is false setting path: subquery -> Linebreak before comparison operator SELECT c.[Categoryid] AS [categoryid],        c.[Categoryname],        c.[Picture] FROM   [northwind].[dbo].[CATEGORIES] c WHERE  (((( (SELECT Sum([lpa_l1].[Unitsinstock]) AS [lpav_]              FROM   (SELECT p.[Categoryid] AS [categoryid],                             p.[Unitsonorder]                      FROM   [northwind].[dbo].[PRODUCTS] p                      WHERE  (( p.[Categoryid] = c.[Categoryid] ))) [lpa_l1]) > @p2 ))))  After…

This format option control whether put a blank line after comparison operator when there is a subquery follows. name: Subquery_Newline_After_ComparisonOperator, default is false setting path: subquery -> Linebreak after comparison operator SELECT * FROM   T WHERE  Somefield = (SELECT TOP 1 Blah                     FROM   T1                     ORDER  BY F)  After set Subquery_Newline_After_ComparisonOperator to…

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…

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…