Padding
Parenthesis
parameters of create procedure/function
gFmtOpt.WSPadding_ParenthesesInFunction
boolean
default: true
function call
gFmtOpt.WSPadding_ParenthesesInFunctionCall
boolean
default: true
expression
gFmtOpt.WSPadding_ParenthesesInExpression
boolean
default: true
combine parenthesis to prevent white space
gFmtOpt.WSPadding_CombineParenthesesToPreventWS
boolean
default: true
assignment expression
gFmtOpt.WSPadding_OperatorAssignment
boolean
default: true
comparison exprssion
gFmtOpt.WSPadding_OperatorComparison
boolean
default: true
Arithmetic expression
gFmtOpt.WSPadding_OperatorArithmetic
boolean
default: true
string concatenation
gFmtOpt.WSPadding_OperatorConcatenationOP
boolean
default: true
bitwise expression
gFmtOpt.WSPadding_OperatorBitWise
boolean
default: true
typename
gFmtOpt.WSPadding_ParenthesesOfTypename
boolean
default: true
after/before
before left parenthesis of function call
gFmtOpt.WSAB_BeforeLeftParenthesesOfFucntionCall
boolean
default: true
before left parenthesis of create procedure/function
gFmtOpt.BEStyle_Function_leftBEIndentSize
integer
default: 1
comma in expr
gFmtOpt.WSAB_BeforeCommaInExpr
boolean
default: false
gFmtOpt.WSAB_AfterCommaInExpr
boolean
default: true
comma in other place
gFmtOpt.WSAS_BeforeCommaGeneral
boolean
default: false
gFmtOpt.WSAS_AfterCommaGeneral
boolean
default: true
space gap while align end line comment
gFmtOpt.WSGap_EndLineComment
integer
default: 2
space before stmt terminator
gFmtOpt.WS_SpaceBeofeStmtTerminator
integer
default:0
space after type name
gFmtOpt.typename_spaceafter
boolean
default: true
SQL before beautify
CREATE PROCEDURE SP_RDELETE
(@SDELETE AS VARCHAR(2000), --DELETE SQL STATEMENT AS PARAMETER
@SCOMMENT AS VARCHAR(1000), --COMMENT/TITLE FOR THE DELETING RECORD(S)
@ERRORMESSAGE AS VARCHAR(2000) --ERROR MESSAGE IF ANY DURING THE SP EXECUTION
)
AS
SELECT AVG(DirectReports) AS [Average Number of Direct Reports]
FROM DirReps
WHERE ((DirectReports + 2) / (20-10))>= 2
and Sal in (1000,2000,3000);
CREATE TABLE AppUser
(
UserID int NOT NULL identity(1,1) ,
FirstName varchar(100) NOT NULL ,
PRIMARY KEY CLUSTERED (UserID ASC)
);
SQL after beautify
CREATE PROCEDURE sp_rdelete ( @SDELETE AS VARCHAR ( 2000 ), --DELETE SQL STATEMENT AS PARAMETER
@SCOMMENT AS VARCHAR ( 1000 ), --COMMENT/TITLE FOR THE DELETING RECORD(S)
@ERRORMESSAGE AS VARCHAR ( 2000 ) --ERROR MESSAGE IF ANY DURING THE SP EXECUTION
)
AS
SELECT Avg ( directreports ) AS [average number of direct reports]
FROM dirreps
WHERE (( directreports + 2 ) / ( 20 - 10 )) >= 2
AND sal IN ( 1000, 2000, 3000 );
CREATE TABLE appuser
(
userid INT NOT NULL IDENTITY ( 1, 1 ),
firstname VARCHAR ( 100 ) NOT NULL,
PRIMARY KEY CLUSTERED ( userid ASC )
);