SQL Formatter Option: Line breaking->Parameters

SQL Format options index ->Line breaking->Parameters

	parameters of create procedure/function
		left parenthesis in new line
			gFmtOpt.BEStyle_Function_leftBEOnNewline
				boolean
				default: false
		indent size of left parenthesis
			gFmtOpt.BEStyle_Function_leftBEIndentSize
				integer
				default: 0
			
		right parenthesis in new line
			gFmtOpt.BEStyle_Function_rightBEOnNewline
				boolean
				default: false
		indent size of right parenthesis
			gFmtOpt.BEStyle_Function_rightBEIndentSize
				integer
				default: 0

		first parameter in new line
			gFmtOpt.BEStyle_Function_FirstParamInNewline
				boolean
				default: false
			
		parameters fit into one line
			gFmtOpt.BEStyle_Function_ParamFitInOneLine
				boolean
				default: false

SQL before beautify

CREATE PROCEDURE SP_RDELETE 
(@SDELETE AS VARCHAR(2000),   
@SCOMMENT AS VARCHAR(1000),   
@ERRORMESSAGE AS VARCHAR(2000)
) 
AS 

--VARIABLE DECLARATION 

DECLARE @SSTR AS VARCHAR(2000),     
@SSELECT AS VARCHAR(2000),    
@STABLE AS VARCHAR(2000),     
@SPOS AS INT

SQL after beautify


CREATE PROCEDURE sp_rdelete ( @SDELETE      AS VARCHAR ( 2000 ),

                              @SCOMMENT     AS VARCHAR ( 1000 ),

                              @ERRORMESSAGE AS VARCHAR ( 2000 ))

AS

    --VARIABLE DECLARATION 

    DECLARE @SSTR    AS VARCHAR ( 2000 ),

            @SSELECT AS VARCHAR ( 2000 ),

            @STABLE  AS VARCHAR ( 2000 ),

            @SPOS    AS INT