开发者

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 easil开发者_开发技巧y 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.


Yes. The SSMS Tools Pack.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜