Seeking a GUI auto-format feature for T-SQL

views:

185

answers:

Seeking a GUI auto-format feature for T-SQL

Is there a freely available GUI tool that will allow interaction with Microsoft SQL Server (via T-SQL) that provides an auto-format feature?

I constantly find myself writing queries in SQL Query Analyzer (Microsoft’s standard GUI tool for T-SQL) and cutting/pasting the whole thing into SQLyog (a GUI tool for MySQL), where I can press F12 and have it reformatted into an easily readable, industry standard format. I then cut/paste this back into Query Analyzer to execute. I do this all the time at work and haven’t been able to find an alternative.

I realize that SQLyog is no longer free software, but what I’m looking for is a specific alternative to a MS SQL Server interface (with auto-formatting). Thanks in advance for your help.

+4 A:

Yes. The SSMS Tools Pack.

Mitch Wheat 2010-05-28 05:11:02

@marc_s: question is not tagged as such.

Mitch Wheat 2010-05-28 06:59:21

Ok, thanks for your feedback. The SSMS Tools Pack is an add-on to SSMS/SQL Server 2005+ and so it’s not technically free, but this is an acceptable answer to my question. Have to accept that working in a proprietary extension of SQL (here T-SQL) locks us into certain tools. I'm going to continue using SQLyog to format my sql statements. The formatting of SQLyog isn’t an industry-standard anyway, I just think it’s the most clear and easily readable format I’ve come across, and it’s what my company uses as a format style, so I’m biased.) Thanks for your help.

dvanaria 2010-05-30 04:12:32

@dvanaria: Hi. The SSMS Tools pack is currently free (there is a donation link, but it is free...)

Mitch Wheat 2010-05-30 04:31:29

+1 A:

If you want to use "SQL Query Analyzer" which is SQL Server 2000 then you have only Red Gate as an option AFAIK.

For SSMS/SQL Server 2005+ there is the SSMS tools pack as mentioned

Edit: SQuirreL has formatting and other plugins that will be better than SSMS tools pack

gbn 2010-05-28 06:43:59

ansaurus

tags:

views:

answers:

Seeking a GUI auto-format feature for T-SQL

related questions