Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Category v238

refer to new sql format options introduced in version 3.2.8

- format option, sql pretty printer, v238

## SQL Formatter Option: Subquery newline after comparison operator

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…

- admin
- September 27, 2011

- format option, sql pretty printer, v238

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

- admin
- September 27, 2011

- format option, sql pretty printer, v238

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

- admin
- September 27, 2011