Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Pretty Printer for T-SQL?

I'm looking for a good T-SQL Pretty Printer so that all the code looks consistent between developers in our project. Preferably a free/open source one, but paid for isn't out of the realms of possibility as long as it's reasonably priced. Are there any particular industry leaders?

I'm not that fussed about what particular standard it uses, but the more configurable the better. That way we can have little style wars among the developers and have a bit of fun to boot. ;-)

I suppose I should add that Visual Studio and Management Studio integration would be considered favourably.

like image 415
pms1969 Avatar asked Apr 08 '10 09:04

pms1969


1 Answers

A free and open source alternative to the paid for options that everyone else has listed is Poor Man's T-SQL Formatter. It integrates nicely with SQL Server Management Studio. The options for configuring how the SQL is formatted are somewhat limited when compared to the other tools, but for the price it's hard to complain, and if you really want to change it, the source is available for you to tweak.

like image 65
JDHnz Avatar answered Sep 21 '22 16:09

JDHnz