I'm using MS Query Analyzer (as part of SQL Server 2000) to write T-SQL scripts to pull data out of a DB. This involves querying some tables, iterating through the results (using a cursor), some basic processing of the results and putting the processed data into another table. This is working pretty well as I can view the tables and stored procedures and edit/run the scripts against them all in Query Analyzer.
我正在使用MS Query Analyzer(作为SQL Server 2000的一部分)编写T-SQL脚本以从数据库中提取数据。这包括查询一些表,迭代结果(使用游标),结果的一些基本处理以及将处理后的数据放入另一个表。这非常有效,因为我可以在查询分析器中查看表和存储过程以及编辑/运行脚本。
The main issue I have is the script editing kinda sux. It's pretty much notepad with syntax highlighting. There's very little understanding of the databases I'm scripting against. And none of the other programming aids that most IDEs provide, eg. code completion on keywords and database table and column names would be very handy.
我的主要问题是脚本编辑有点sux。它几乎是带有语法高亮的记事本。我对脚本编写的数据库知之甚少。并且没有其他编程辅助大多数IDE提供的,例如。关键字和数据库表和列名的代码完成将非常方便。
My question is: are there any tools that provide a better T-SQL scripting environment, while maintaining the same (or better) level of integration with SQL Server? Free/open source tools would be preferred, but commerical ones would also be considered.
我的问题是:是否有任何工具可以提供更好的T-SQL脚本环境,同时保持与SQL Server相同(或更好)的集成水平?免费/开源工具将是首选,但也会考虑商业/工具。
3 个解决方案
#1
I think it's called SQL Server 2008 Management Studio :). It has intellisense support now.
我认为它叫做SQL Server 2008 Management Studio :)。它现在有智能支持。
If not, you can try add-in from Red Gate like Sql Prompt.
如果没有,您可以像Sql Prompt一样尝试Red Gate的加载项。
#2
I've tried this and personally think that is a better offer than Microsoft one, plus its free!
我已经尝试过这个,并且个人认为这是一个比微软更好的报价,加上它的免费!
http://www.albahari.com/queryexpress.aspx
Hope it serves!
希望它服务!
#3
I agreed with using of Management Studio (check these improvements to SSMS ). You can use Management Studio to work with your MS SQL 2000 servers. Also you can use Visual Studio 2005 or 2008 with Database projects.
我同意使用Management Studio(检查SSMS的这些改进)。您可以使用Management Studio来使用MS SQL 2000服务器。您还可以将Visual Studio 2005或2008与数据库项目一起使用。
#1
I think it's called SQL Server 2008 Management Studio :). It has intellisense support now.
我认为它叫做SQL Server 2008 Management Studio :)。它现在有智能支持。
If not, you can try add-in from Red Gate like Sql Prompt.
如果没有,您可以像Sql Prompt一样尝试Red Gate的加载项。
#2
I've tried this and personally think that is a better offer than Microsoft one, plus its free!
我已经尝试过这个,并且个人认为这是一个比微软更好的报价,加上它的免费!
http://www.albahari.com/queryexpress.aspx
Hope it serves!
希望它服务!
#3
I agreed with using of Management Studio (check these improvements to SSMS ). You can use Management Studio to work with your MS SQL 2000 servers. Also you can use Visual Studio 2005 or 2008 with Database projects.
我同意使用Management Studio(检查SSMS的这些改进)。您可以使用Management Studio来使用MS SQL 2000服务器。您还可以将Visual Studio 2005或2008与数据库项目一起使用。