SQL Prompt Layout Request

Our current standard look like this
DECLARE @bulk_cmd..............VARCHAR(1000)
DECLARE @ErrMsg..................VARCHAR(1000)
DECLARE @TradPartId.............SMALLINT
DECLARE @InterFmtCode........NUMERIC(6)

DECLARE @FilePath.................VARCHAR(500),
[email protected],
[email protected]


The dots are actual spaces. Typed it in to show spacing. Makes it much more readable especially if the procedure is a biggy


SQL Prompt change this to
DECLARE @bulk_cmd VARCHAR(1000)
    DECLARE @ErrMsg VARCHAR(1000)
    DECLARE @TradPartId SMALLINT
    DECLARE @InterFmtCode NUMERIC(6)

    DECLARE @FilePath VARCHAR(500),
        @RestartAt INT,
        @StepId INT



My suggestion is that you add an option to allow formatting as our current standard indicates.

Comments

  • Thanks for your post.

    As you have discovered, SQL Prompt doesn't allow you to format your variables in this way.

    I have added it as a suggestion, so hopfully it will be considered for a future version.

    for your reference the feature tracking code is SP-1904
    Chris
  • We use the same standard as the original poster, any chance there's been an update on this? Would be great to see it, greatly improves readability of variable defs.
Sign In or Register to comment.