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

# SQL Formatter Option: Subquery newline after IN keyword

- admin
- September 27, 2011
- format option, sql pretty printer, v238

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 set Subquery_Newline_After_IN to true, SQL will be formatted like this:

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) ))) )

### Newsletter Updates

Enter your email address below to subscribe to our newsletter

I accept the Privacy Policy

### Related Posts

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.3

- September 19, 2012

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2

- July 18, 2012

#### SQL Pretty Printer works when Multi-SSMS installed

- July 5, 2012