terminator stmt gFmtOpt.MDF_KeepStmtTerminator integer 0: no change 1: add if possible 2: remove default: 0 insert parenthesis in condition of if/while gFmtOpt.MDF_WrapParenthesisIfCondition boolean default: false add begin/end pair for single statement in if/while gFmtOpt.MDF_WrapBeginEndIf boolean default: false
CREATE PROCEDURE SP_RDELETE (@SDELETE AS VARCHAR(2000) ) AS IF @@ERROR > 0 ROLLBACK TRANSACTION TRANS_SP_DELETE ELSE BEGIN --COMPLETED SUCCESSFULLY COMMIT TRANSACTION TRANS_SP_DELETE ; RETURN 0 END
CREATE PROCEDURE sp_rdelete ( @SDELETE AS VARCHAR ( 2000 ))
AS
IF @@ERROR > 0
ROLLBACK TRANSACTION trans_sp_delete
ELSE
BEGIN
--COMPLETED SUCCESSFULLY
COMMIT TRANSACTION trans_sp_delete;
RETURN 0
END