Geek Answers Handbook

SQL Scripting Tool that surpasses MS Query Analyzer?

I use MS Query Analyzer (as part of SQL Server 2000) to write T-SQL scripts to extract data from a database. This includes querying some tables, repeating the results (using the cursor), some basic processing of the results, and transferring the processed data to another table. This works very well, since I can view tables and stored procedures, as well as edit / run scripts using them in Query Analyzer.

The main question I have is editing the script kinda sux. This is pretty much a syntax highlight notebook. There is very little understanding of the databases that I come across. And none of the other software tools support most IDEs, for example. code completion for keywords and database tables and column names would be very convenient.

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? Open source tools would be preferable, but commercial ones would also be considered.

+4
source share
3 answers

I think this is called SQL Server 2008 Management Studio :). Now it supports intellisense.

If not, you can try an add-in from Red Gate, such as Sql Prompt.

+1
source

I have tried this and I personally think that this is a better offer than Microsoft, plus its free!

http://www.albahari.com/queryexpress.aspx

Hope he serves!

+3
source

I agreed to use Management Studio (check out these improvements on SSMS). You can use Management Studio to work with MS SQL 2000 servers. You can also use Visual Studio 2005 or 2008 with database projects.

0
source

More articles:


All Articles