满足脚本/开发需求的最佳Sql Server IDE

I am looking for the best Sql Server IDE for scripting / development needs. Must haves:

  • Visual GUI for creating complex queries
  • Intellisense for all db objects
  • Auto-format capability to format SQL script to a particular format / coding standard.
  • SELECT Sql output to .xls, .txt with custom choices in delimiters / format

Cost is not an issue. When you make a recommendation, can you state why you prefer it, and what other IDEs you have tried before. Thank you.

#0

SQL Management Studio with SQL Assistant (www.softtreetech.com) or SQL Prompt (www.red-gate.com)

#1

I would suggest looking at SQL Everywhere. I have completely moved off of MS SQL Studio Management tool. The biggest advantage to SQL Everywhere for me is auto-complete (Intelisense) even against a SQL 2005 server. The format SQL feature is ok.

#2

Anything wrong with the management studio that comes with Sql Server? The 2008 version meets all your requirements.

[edit]: I take it back: it can do autoformatting in the right circumstances, but it's painful and to my knowledge doesn't allow you to specify the coding standard. Also, the intellisense is weak.

#4

Try out

I personally like EMS SQL Manager Lite, its not so lite in making your job easier, trust me :)

#5

ApexSQL Edit. Not wild about their GUI query editor, but great on intellisense and formatting. Also includes options to copy out of the result set to Excel, CSV, and HTML via clipboard and some handy custom column copying tools. I'm practically crippled in SSMS because ApexSQL Edit has me so spoiled.

#6

As a well-performing tool for SQL developers I can recommend dbForge Studio for SQL Server. It matches all your requirements. Specifically it has: - Visual query builder that enables creating complex queries - Intellisense that is comparable one provided by SQL Prompt - SQL script formatting with multiple options - SELECT output export to .xls and .txt plus 6 other formats (has wizard for export customization)

推荐文章

从Elastic MapReduce HDFS获取数据

从Elastic MapReduce HDFS获取数据

推荐文章

在.NET中创建报表网站的工具?

在.NET中创建报表网站的工具?

推荐文章

这个够安全吗?

这个够安全吗?

推荐文章

Bat not like“,”代表x、y、c

Bat not like“,”代表x、y、c

推荐文章

当我结合一个按钮点击和一个异步联系人调用时,无限循环

当我结合一个按钮点击和一个异步联系人调用时,无限循环

推荐文章

设置sbt以使用java7进行编译?

设置sbt以使用java7进行编译?

推荐文章

为什么move_uploaded_文件不起作用?

为什么move_uploaded_文件不起作用?

推荐文章

在cakephp中使用AJAX连接多个字段以在自动完成中显示

在cakephp中使用AJAX连接多个字段以在自动完成中显示

推荐文章

子串与索引函数

子串与索引函数

推荐文章

行动困难

行动困难

推荐文章

如何将时区配置添加到环境.rb文件?

如何将时区配置添加到环境.rb文件?

推荐文章

回调时Omniauth 404

回调时Omniauth 404

推荐文章

PlayFramework如何使部署比传统Java框架运行速度更快的web应用程序成为可能?

PlayFramework如何使部署比传统Java框架运行速度更快的web应用程序成为可能?

推荐文章

在iOS上,根据与当前位置的距离对实体进行排序的最佳策略是什么

在iOS上,根据与当前位置的距离对实体进行排序的最佳策略是什么

推荐文章

PHP数组输出为JSON格式

PHP数组输出为JSON格式

推荐文章

PHP中HTML表单的提交和处理

PHP中HTML表单的提交和处理