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