Expression(and/or)
gFmtOpt.Expr_AndOrWithNewline
integer
0: after newline
1: before newline
2: no newline
default:0
gFmtOpt.Expr_AndOrAlignWithTopLevelExpr
boolean
default: true
gFmtOpt.AndOrAlignWhereClause
boolean
default:false
SQL before beautify
SELECT AddressLine1, AddressLine2, City, PostalCode, CountryRegionCode
FROM Person.Address AS a
JOIN Person.StateProvince AS s ON a.StateProvinceID = s.StateProvinceID
WHERE CountryRegionCode NOT IN ('US')
AND City LIKE N'Mn%' or PostalCode like '57%'
AND City LIKE N'Mn%' or PostalCode like '57%'
AND City LIKE N'Mn%' or PostalCode like '57%'
;
SQL after beautify
SELECT addressline1,
addressline2,
city,
postalcode,
countryregioncode
FROM person.address AS a
JOIN person.stateprovince AS s
ON a.stateprovinceid = s.stateprovinceid
WHERE countryregioncode NOT IN ( 'US' )
AND city LIKE N'Mn%'
OR postalcode LIKE '57%'
AND city LIKE N'Mn%'
OR postalcode LIKE '57%'
AND city LIKE N'Mn%'
OR postalcode LIKE '57%';