I create a fair amount of T-SQL in the form of selects, views and stored procedures. While I try to format my code to make it easy to use, I do encounter code from other people which is not very well formatted; and if you look at the stored procedures or views which ship with Microsoft Dynamics GP, they are generally formatted with all of the code on a single line.
There are a variety of ways of formatting SQL and I’m sure there are addins for SQL Server Management Studio; however, I often work on clients servers and can’t just install anything I want.
Therefore, a web based alternative is favourite and SQLFormat is the best one I have come across so far.
To use, simple paste your code into the big box and click the Format SQL button:
You can even load a file should you wish.
I’m posting it here as a reminder to myself.
ISC Software Solutions
are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals
, or anything else Dynamics GP related, you can use the form below.