SQL Prompt Layout Request

jean.dutoit@pbtit.co.za

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.

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

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.