PoorMansTSqlFormatter icon indicating copy to clipboard operation
PoorMansTSqlFormatter copied to clipboard

Option: Parameters and Declarations

Open evancamilleri opened this issue 4 years ago • 0 comments

ALTER PROCEDURE [dbo].[spr_TEST] @date DATE
	,@location BIGINT
AS
BEGIN
    DECLARE @C_SIMPHONY INT = 22005
	,@abc BIGINT = 4
END

to show as

ALTER PROCEDURE [dbo].[spr_TEST] @date     DATE
                               , @location BIGINT
AS
BEGIN
    DECLARE @C_SIMPHONY INT    = 22005
          , @abc        BIGINT = 4
END

i.e. variable names under each other, variable types under each other, ideally also any = to define default under each other ideally a space after the , as well

evancamilleri avatar Nov 13 '20 11:11 evancamilleri