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 comparison operator

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

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

SELECT *
FROM T
WHERE Somefield =
(SELECT TOP 1 Blah
FROM T1
ORDER BY F)

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