TSQL Code formatter - SQL Server 2005/2008 [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

开发者_StackOverflow中文版 Improve this question

Is there a free code formatter available for TSQL - SQL Server 2005/2008. I found few most of which asks to copy paste code online in an applet. I am looking for a desktop version. Tried toad for sql server but formatting is not supported in freeware. If anyone has any work-around please share it.

---

I've been working on a formatter for the past few months, I just release the official version v1.0, with no (major) known issues.

It's available for immediate online use at http://poorsql.com, and the project with SSMS Add-In, command-line formatter ready-to-download is available at http://www.architectshack.com/PoorMansTSqlFormatter.ashx.

I know it's been a long while since this question was posted, but I'd love any sort of feedback.

(Edit: updated status)

---

Check out the SSMS Tools Pack (free addon for SSMS).

One of the features is formatting (http://www.ssmstoolspack.com/Features?f=3), though I don't know what level you want your SQL formatted - maybe you could clarify?

---

SQLISE has a formating function, you can set a number of formatting options. It is free. It is a codeplex project based on PowerShell.

Drawback it removes all comments link text

---

This online tool does excellent sql formatting. http://sqlserverlearner.com/online-tools/tsql-code-formatter

I use it to format tsql code