I am always trying to keep a "tight clean ship", or whatever the original English saying is, even though it looks like a "monkey business" to manually format any word that I am typing. I am even using the square brackets ('
[' and '
]') in order to enclose any data type or variable, even when it does not contain any spaces.
However, doing this kind of work for hundreds of stored procedures looks like a titanic work. How to get things nicely formatted, without working unnecessarily?
From the available formatting tools, I have found
SQL Pretty Printer that looks quite intelligent and that I might even install when I have enough rights to download more than two bytes of data from the outer, non-corporate cybernetic world. Security can be daunting these days.
Also, I am not using any source control and therefore I have to rely on my own insect-like prismatic brain in order to understand whatever I have modified, along the way. This way, I have to use comparing tools like
WinMerge, or the one that is included inside
Total Commander. Possibly, they might already have some facilities for
T-SQL that I have not figured out yet.