SQL Formatter for SQL Management Studio

Question

I was wondering if there is a plugin/tool for SQL Server Management Studio that will format your SQL?

I'm working with some large-ish stored procs that are a mangled mess of poorly formatted SQL and it'd be nice if I could just go "Select All -> Format SQL"

Answer 1

Red-Gate makes a couple, either Sql Prompt Pro or Sql Refactor. There are a million others out there that do not plug into management studio, but Red-Gate makes the only plugin I know of and it works very well. They also provide intelli-sense and a few other useful features.

http://www.red-gate.com/products/SQL_Prompt/index.htm

Answer 2

This one (Gudu Software) is pretty good, works in Management Studio and is pretty cheap. It needs more options in my opinion but haven't used it for a few months, maybe they've added some new features. I was happy with it when I used it. Also has a free online version.

Answer 3

This is a free, online one: http://www.sqlinform.com/ (requires Java Runtime Environment)

Answer 4

Today I discovered Apex SQL Refactor. It is a free plugin. Integrates with SSMS. Downside is that it is an all or nothing process. It does not refactor as you type.

Answer 5

Not a plugin for SSMS, but I find this handy to keep as a bookmark in my browser: http://www.dpriver.com/pp/sqlformat.htm

Edit: Oops - I just noticed they have versions for SSMS, Visual Studio, and a desktop version etc. Haven't tried them personally yet.

Answer 6

Check SQL Enlight.

Answer 7

SSMS Tools Pak does a good job of formatting and the other tools in the pack come in quite handy

Answer 8

Or you could try my formatter.It is not free. it is a command line tool and it can integrated with SSMS as an external tool.... Tidycode T-Sql Formatter

Answer 9

This web site here does basic SQL keyword capitalisation:

http://www.ascdesc.com