SQL Pretty Printer Add-In for SSMS – Review

I came across an online Instant SQL Formatter a while back and have been using that for some time to format SQL code that I get from other people.  Now I see there is an add-in for SQL Management Studio from the same author of the online version. I downloaded and installed the SQL Pretty Printer Add-In For SSMS (not free) and have really found it very helpful.

Once installed, you will see the following toolbar in SSMS.

I created a couple of quick queries without paying too much attention to formatting.

Here is the same code after using the Pretty Printer SQL Formatter. Nice!

There are also numerous settings for the formatting, which is also very cool.

In closing, if you are like me and have an OCD when it comes to consistently formatted code, you will find this tool useful. The place where it is really useful and time-saving is on REALLY long Stored Procedures. I have had to deal with this lately, so I use this tool daily.

SQL Pretty Printer Add-In for SQL Server Management Studio

Instant SQL Formatter

–

Until next time…