Indent SET to line up variable name with the DECLARE
I like to indent SET so my variable names line up with DECLARE. For instance:
DECLARE @Variable int;
------- SET @Variable = 0;
(the hyphens are my HTML workaround would actually be spaces)
2
votes
Josh
shared this idea
We’ve released a new formatting engine in SQL Prompt Version 8.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
Simon
commented
I'd like the variable name to be lined up but would suggest the spaces come after SET not before, so the example would be:
DECLARE @Variable INT;
SET - - - - @Variable = 0; -
Josh
commented
FYI, Using two lines for DECLARE/SET is necessary for backward compatibility.