block that keep layout
-- begin_no_format
-- end_no_format
align continuously end of line comment
gfmtopt.CMT_AlignContinuouslyEndOfLineComment
boolean
default: true
space between last token and comment in the same line
gfmtopt.WSGap_EndLineComment
integer
default: 2
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
IF @@ERROR > 0
BEGIN
COMMIT TRANSACTION TRANS_SP_DELETE ;
-- begin_no_format
INSERT INTO Cities (Location)
VALUES ( 'Location in
two lines'
);
-- end_no_format
RETURN 0
END
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
IF @@ERROR > 0
BEGIN
COMMIT TRANSACTION trans_sp_delete;
-- begin_no_format
INSERT INTO Cities (Location)
VALUES ( 'Location in
two lines'
);
-- end_no_format
RETURN 0
END