Options
SQL Prompt Layout Request
jean.dutoit@pbtit.co.za
Posts: 2
Our current standard look like this
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
My suggestion is that you add an option to allow formatting as our current standard indicates.
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.
Comments
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