blocks|key|3746660|text|也许先试试SQL+Manager+Express吧。如果您需要更多，您可以随时寻找其他解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746661|编辑：这是针对MS+SQL2005Express的。我希望MS+SQL+Express+2008会有一个新的版本，它会比VS2005快得多。|style|BOLD|3746662|更新：MSSQL2014开发人员版对于开发目的是免费的。它包含功能齐全的SQL+Manager。|3746663|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en^0|5|J|0|0|0|2|0|0|2|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@$A|W|B|X|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|Y|8|@$A|Z|B|10|F|G]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

Maybe try <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&amp;DisplayLang=en" rel="nofollow noreferrer">SQL Manager Express</a> first. If you need more, you can always look for other solutions.

Edit: This was for MS SQL 2005 Express. I hope that there will be a new one for MS SQL Express 2008, and it will be much quicker like VS 2008 compared to VS 2005.

Update: MSSQL 2014 Developer Edition is free for development purposes. It contains SQL Manager with full funcionality.

blocks|key|5158016|text|azure_ardee，我在找松鼠的Windows身份验证如果使用jtds驱动程序，则可以将属性域添加到连接字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5158017|conn字符串的sintax是:+jdbc:jtds:sqlserver://:<1433>/[;=;...]|5158018|例如:+jdbc:jtds:sqlserver://hostname:1433/db_name;DOMAIN=my_domain|5158019|此外，您还可以单击Properties按钮，检查域属性并使用域名填充值。|5158020|我希望我能帮上忙！|5158021|Nakro|5158022|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

azure_ardee, i've looking for the Windows Authentication on Squirrel. If you use the jtds driver you cand add the property DOMAIN to the connection string.

The sintax for the conn str is:
jdbc:jtds:sqlserver://[:&lt;1433>]/[;=[;...]]

For example:
jdbc:jtds:sqlserver://hostname:1433/db_name;DOMAIN=my_domain

Also, you can click the Properties button, check the DOMAIN property and fill the value with the domain name.

I hope i helped!

Nakro

blocks|key|3746701|text|我喜欢Aqua+Data+Studio。它是Java，但不要被关闭，它的性能非常好。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746702|entityMap|0|LINK|mutability|MUTABLE|url|http://www.aquafold.com/^0|3|G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I like <a href="http://www.aquafold.com/" rel="nofollow noreferrer">Aqua Data Studio</a>. 
It's Java but don't be turned off, it performs very well.

blocks|key|3746737|text|还有来自Redgate的SQL+Prompt，它有更多的花哨花哨的东西，你可以戳一戳(只有MSSQL，它不是免费的)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746738|在这个范围的另一端是完全基本的Query+Express|3746739|entityMap|0|LINK|mutability|MUTABLE|url|http://www.red-gate.com/Products/SQL_Prompt/index.htm|1|http://www.albahari.com/queryexpress.html^0|C|A|0|0|F|D|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

There's also <a href="http://www.red-gate.com/Products/SQL_Prompt/index.htm" rel="nofollow noreferrer">SQL Prompt</a> from Redgate which has more bells and whistles than you can poke a stick at (MSSQL Only and it's not free)

At the other end of the spectrum is the completely barebones <a href="http://www.albahari.com/queryexpress.html" rel="nofollow noreferrer">Query Express</a>

blocks|key|3746614|text|好吧，如果你喜欢TOAD，那就用there+TOAD+supports+that+too吧。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746615|entityMap|0|LINK|mutability|MUTABLE|url|http://www.quest.com/toad/^0|G|S|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Well if you liked TOAD then <a href="http://www.quest.com/toad/" rel="nofollow noreferrer">there TOAD supports that too</a>.

blocks|key|2902465|text|我没有用过它们，但它们是免费的，而且它们声称是独立于DBMS的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2902466|http://www.isqlviewer.com/|offset|length|2902467|http://www.sql-workbench.net/index.html|2902468|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|Q|0|0|0|13|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|H|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]|O|$5|K|L|M|A|$N|G]]]]

I haven't used them, but they are free and they claim to be DBMS-independent: 
<a href="http://www.isqlviewer.com/" rel="nofollow noreferrer">http://www.isqlviewer.com/</a> 
<a href="http://www.sql-workbench.net/index.html" rel="nofollow noreferrer">http://www.sql-workbench.net/index.html</a>

blocks|key|3746856|text|我们办公室的开发人员开始使用甲骨文(http://www.oracle.com/technology/products/database/sql_developer/index.html)的免费SQLDevolper工具。我仍然对PL/SQL+Developer+(http://allroundautomations.com/)非常满意。和TOAD一样，它们都有一个较小的学习曲线，但是一旦您对它们有了感觉，很难想象会回到SQL工作表提示符。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746857|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/products/database/sql_developer/index.html|1|http://allroundautomations.com/^0|I|23|0|3P|V|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Developers in our office are starting to use the free SQLDevolper tool by Oracle (<a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow noreferrer">http://www.oracle.com/technology/products/database/sql_developer/index.html</a>). I am still very happy with PL/SQL Developer (<a href="http://allroundautomations.com/" rel="nofollow noreferrer">http://allroundautomations.com/</a>). Both have a minor learning curve, as does TOAD, but once you get the feel of them it's hard to imagine going back to the SQL Worksheet prompt.

blocks|key|5157621|text|Oracle+SQL+Developer非常好，也可以与SQL+Server一起使用。你也可以试试DB+Solo+3，这两个都是跨平台的应用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5157622|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Oracle SQL Developer is very good and also works with SQL Server. You could also try DB Solo 3. Both of these are cross platform applications.

blocks|key|3746914|text|我用Toad，但我讨厌它。它是有缺陷的，但对我来说，它可以完成工作。我一直对Embarcadero印象深刻，你可以看出他们知道如何设计软件。如果我有钱，我可能会从他们那里买一个工具。在评估了一大堆其他产品后，我们最近购买了E/R+studio。我从来不喜欢Oracle提供的东西，但它是免费的，所以在您的情况下，我会选择它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746915|entityMap|0|LINK|mutability|MUTABLE|url|http://www.embarcadero.com/^0|12|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I use Toad, but hate it. It is buggy but for me it gets the job done. I have always been impressed with <a href="http://www.embarcadero.com/" rel="nofollow noreferrer">Embarcadero</a>, you can tell they know how to design software. If I had the money I would probably buy a tool from them. We recently purchased E/R studio after evaluating a ton of other products. I have never liked what Oracle puts out but it is free so in your case I would go with that.

blocks|key|3746919|text|SQL+Navigator是另一种可能性|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3746920|entityMap|0|LINK|mutability|MUTABLE|url|http://www.questsoftware.de/Quest_Site_Assets/PDF/SQLNavigator_554_ReleaseNotes.htm^0|0|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.questsoftware.de/Quest_Site_Assets/PDF/SQLNavigator_554_ReleaseNotes.htm" rel="nofollow noreferrer">SQL Navigator</a> is another possibility

blocks|key|2902627|text|我喜欢EMS+SQL+Manager，它们有适用于所有主要数据库的版本。如果你像我一样使用Oracle，ms-sql，mysql和postgres，那么至少你的日常查询/管理工具在所有平台上看起来都是一样的|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2902628|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlmanager.net/^0|3|F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I like <a href="http://sqlmanager.net/" rel="nofollow noreferrer">EMS SQL Manager</a> They have versions for all the major db's. Same interface, so if you, like me, use Oracle, ms-sql, mysql and postgres then at least your day to day query/management tool will look the same for all platforms

blocks|key|5157835|text|如果要使用SQL+Server，请使用MS.提供的工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5157836|如果你想要你习惯的动力玩具，那么看看RedGate的产品，它们拥有你梦寐以求的一切。TOAD+for+SQL+Server也始终是一个选项。|5157837|SqlDeveloper不允许你使用Windows+Authentication连接到服务器，你需要一个ODBC，我希望类似的免费工具也是如此。|5157838|您还可以使用MS+Access并创建adp项目。将不会有本地查询。它将直接在服务器上完成所有工作。创建查询将在服务器中创建一个视图。|5157839|我更喜欢使用MS+Management+Studio+(免费工具，随服务器一起提供)和Visual+Studio。|5157840|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

If you are going to work with SQL Server then use the tools provided by MS. 

If you want the power toys as you got used to have in TOAD then look at RedGate products, they have everything you would dream of. TOAD for SQL Server is always an option too.

SqlDeveloper would not let you connect to the server using Windows Authentication, you will need an ODBC, and I expect the same for similar free tools.

You can also use MS Access and create an adp project. There will be no local queries. It would do all the work directly on the server. Creating a query will create a view in the server.

I prefer to stick to MS Management Studio (free tool, comes with the server) and Visual Studio.

blocks|key|708837|text|我们提供了一个很好的可视化查询构建工具，称为dbForge+Query+Builder+for+SQL+Server。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|708838|entityMap|0|LINK|mutability|MUTABLE|url|http://www.devart.com/dbforge/sql/querybuilder/^0|M|10|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

We offer a nice visual query building tool, called <a href="http://www.devart.com/dbforge/sql/querybuilder/" rel="nofollow noreferrer">dbForge Query Builder for SQL Server</a>.

blocks|key|704021|text|QweryBuilder同时支持SQL+Server和Oracle。还有一个免费的Express版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|704022|entityMap|0|LINK|mutability|MUTABLE|url|http://www.werysoft.com/|1|http://www.werysoft.com/freesqleditor.aspx^0|0|C|0|15|7|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

<a href="http://www.werysoft.com" rel="nofollow">QweryBuilder</a> supports both SQL Server and Oracle. There is also a free <a href="http://www.werysoft.com/freesqleditor.aspx" rel="nofollow">Express</a> version available.

blocks|key|2902563|text|尝试squirrel+SQL+client。http://www.squirrelsql.org/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2902564|entityMap|0|LINK|mutability|MUTABLE|url|http://www.squirrelsql.org/^0|M|R|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try squirrel SQL client. <a href="http://www.squirrelsql.org/" rel="nofollow noreferrer">http://www.squirrelsql.org/</a>

I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in that it was super intuitive and really easy to use and I'm hoping to find something similar for MS SQL Server. Something open source or free is preferable, since I doubt my client will want to pay for anything, but I'm willing to hear suggestions of things that cost money if they are far and away the best in class tool available.

SQL/Query tools?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

几年来，我并没有真正完成大量的数据库工作，对可用的工具也变得不太习惯。几年前，我正在使用oracle数据库，主要使用TOAD和一些MS Access作为我选择的工具，以构建我在应用程序中使用的查询的原型。我真的很喜欢TOAD，因为它超级直观，非常容易使用，我希望能为MS SQL Server找到类似的东西。开源或免费的东西更可取，因为我怀疑我的客户是否愿意为任何东西付费，但如果它们是同类中最好的工

问SQL/查询工具？
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL/查询工具？EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL/查询工具？
EN