insert
field items
field items fit into onelines
gFmtOpt.Insert_FieldInOneLine
integer
0: fit into oneline
1: one item each line
default: 1
left parenthesis in newline
gFmtOpt.Insert_FieldLeftparenInNewline
boolean
default: false
space before left parenthesis
gFmtOpt.Insert_FieldSpaceBeforeLeftParen
integer
default: 0
Parenthesis padding
gFmtOpt.Insert_FieldParenthesisPadding
boolean
default: false
right parenthesis in newline
gFmtOpt.Insert_FieldRightParenInNewline
boolean
default: false
space before right parenthesis
gFmtOpt.Insert_FieldSpaceBeforeRightparen
integer
default: 0
first field item in newline
gFmtOpt.Insert_FieldFirstItemInNewline
boolean
default: false
value items
value items fit into onelines
gFmtOpt.Insert_ValueInOneLine
integer
0: fit into oneline
1: one item each line
default: 1
left parenthesis in newline
gFmtOpt.Insert_ValueLeftparenInNewline
boolean
default: false
space before left parenthesis
gFmtOpt.Insert_ValueSpaceBeforeLeftParen
integer
default: 0
Parenthesis padding
gFmtOpt.Insert_ValueParenthesisPadding
boolean
default: false
right parenthesis in newline
gFmtOpt.Insert_ValueRightParenInNewline
boolean
default: false
space before right parenthesis
gFmtOpt.Insert_ValueSpaceBeforeRightparen
integer
default: 0
first value item in newline
gFmtOpt.Insert_ValueFirstItemInNewline
boolean
default: false
SQL before beautify
INSERT INTO Production.UnitMeasure (Name, UnitMeasureCode,
ModifiedDate,Width)
VALUES (N'Square Yards', N'Y2', GETDATE(),10);
SQL after beautify
INSERT INTO production.unitmeasure(name,
unitmeasurecode,
modifieddate,
width)
VALUES (N'Square Yards', N'Y2', Getdate ( ), 10);