I have to modify some lengthy stored procs in a proprietary database, where all carriage returns and comments have been deleted.
Right now I'm manually re-entering the carriage returns in order to read the code, but this is very tedious.
Are there any tools to do this?
Thanks in advance.
Look at redgates tool...
Hello,
You have to create your own style based upon the written and unwritten rules. I tested the red gate utility and others as well, but your hand, with your eyes do the code formatting to crystal clear.
I don't know what is your problem... you inherited this unstructured megamix? what do you want to do?
brush
I too absolutely love the Red Gate tools. However, even with their modest cost, you might not be able to afford them. Instead, try the Simple-Talk Code Prettifier.
For what it's worth, there's a T-SQL parser set for compatibility levels 80, 90 and 100 that comes with the GDR release for VSTS Team Suite Database Nerd Edition. I can never remember exactly what it's called!
That's what my sql editor uses under the hood. It doesn't preserve comments, which is highly annoying (thanks for that Microsoft), but seeing as you don't have any comments, it's probably worth a look.
Another tool that includes formatting is Apex SQL Edit. There is also a free on-line prettifier here.
