SQL formatting tools

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

etirem SSCommitted Points: 1655 More actions · Answer 3

Also..the software need to identify the objects while typing.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

etirem (6/21/2012)
Also..the software need to identify the objects while typing.

Do you mean intellisense? There is a version built into SSMS 2008 but...it is less than optimal. Redgate sql prompt is really slick but it isn't free.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

SQLComplete free does both (code formatting and intellisense).

Works quite well.

-- Gianluca Sartori

praneshram SSChasing Mays Points: 631 More actions · Answer 6

Hi,

I am using the below one. But really no idea whether it copies your code into their server (kind of leakage).

http://www.dpriver.com/pp/sqlformat.htm

Thanks

Pranesh