How can we help you today? How can we help you today?

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),
..............@RestartAt...............INT,
..............@StepId...................INT


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.
jean.dutoit
0

Comments

2 comments

Sort by
  • Chris Auckland
    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 Auckland
    0
  • Endareth
    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.
    Endareth
    0

Add comment

Please sign in to leave a comment.