Formatting SQL

Useful WebsitesAt the start of March last year, I posted about a site you can use to format SQL by pasting it in or uploading a file. That site is still present and working, but I’ve found a new website which formats SQL more to my liking (thinking specifically of formatting some of the Microsoft Dynamics GP stored procedures).

The new site I’m using is SQL Formatter from DevArt:

SQL Formatter

The SQL in the above is from my SQL View to Return Budgets by Month post.

Using the options to the right, you can change how the SQL is formatted, so you can alter how the SQL is formatted to make it closer to your required output.

I prefer a web based solution as I sometimes need to format SQL when I’m working on a client system and don’t have access to my own laptop, so one of the tools which can install into SQL Server Management Studio aren’t always usable.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?





Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *