select
select list
fit into one line
gFmtOpt.Select_ListitemFitInOneLine
integer
0: fit into oneline
1: one item per line
default: 1
first select item in new line
gFmtOpt.Select_ListitemInNewLine
boolean
default: false
comma in new line
gFmtOpt.Select_ListitemCommaInNewLine
boolean
default: false
align by field name
gFmtOpt.Select_ListitemAlignByName
boolean
default: false
space after comma
gFmtOpt.Select_ListitemSpaceBeforeComma
integer
default: 0
space before comma
gFmtOpt.Select_ListitemSpaceAfterComma
integer
default: 0
from clause
first table in new line
gFmtOpt.Select_FromclauseInNewLine
boolean
default: false
comma in new line
gFmtOpt.Select_FromclauseCommaInNewline
boolean
default: false
space after comma
gFmtOpt.Select_FromclauseSpaceAfterComma
integer
default: 0
space before comma
gFmtOpt.Select_FromclauseSpaceBeforeComma
integer
default: 0
align table name
gFmtOpt.Select_FromclauseAlignByTablename
boolean
default: true
JoinOn clause InNewline
gFmtOpt.Select_FromclauseJoinOnInNewline
boolean
default: true
indent of JoinOn clause
gFmtOpt.Select_FromclauseJoinOnIndentSize
integer
default: 2
SQL before beautify
SELECT p.name AS product,
p.listprice AS 'List Price'
FROM production.product p
JOIN production.productsubcategory s
ON p.productsubcategoryid = s.productsubcategoryid
WHERE s.name LIKE @product
AND p.listprice < @maxprice;
SQL after beautify
SELECT p.name AS product,
p.listprice AS 'List Price'
FROM production.product p
JOIN production.productsubcategory s
ON p.productsubcategoryid = s.productsubcategoryid
WHERE s.name LIKE @product
AND p.listprice < @maxprice;