我正在设计一个供公司内部使用的数据库，该数据库将存储我的团队成员生成的数据。 虽然 SQL Server 将仅安装在一台服务器计算机上，但我的团队成员将需要能够访问数据并从自己的终端对其运行筛选/选择查询（例如，搜索来自指定品牌的产品）在某项测试中获得最高分）。 显然，我可以设计一个 Web 界面或 C# 应用程序来执行此操作，但我确信已经有一个客户端应用程序也可以实现此目的。
那么有吗？ 甚至像免费的微软下载？ 我想我真正想要的是某种查询生成器。 我记得以前使用 Access 时，它有一个很好的 GUI，可以用最大/最小/平均选项和充足的拟合器来组成漂亮的小查询； 这就是我正在寻找的。
另外，表管理（如 PHPMyAdmin）会很好，但不是必需的。 我的团队成员需要做的主要事情是运行选择查询，就像我在第一段中给出的示例一样。 他们甚至不一定需要进行插入，因为我为此设置了一个单独的系统。
谢谢！
PS我发现 Acitve QueryBuilder 和 DbVisualizer 通过 Google，它们看起来都很棒。 然而，它们也都需要花钱。 有免费的替代方案吗？ 或者，如果没有，这两个是我找到的好的查询构建器吗？ 或者还有其他更好的吗？
更新：我刚刚意识到，虽然我无法在所有团队成员的终端上安装 SQL Server Developer，但我可以安装 Express 版本，其中包括管理工作室。 我是该软件的新手，但我会弄乱它，看看它是否符合我的要求，然后发回......
I'm designing a database for internal use at my company that will store data that is produced by my team members. While SQL Server will be installed only on a single server machine, my team members will need to be able to access the data and run filter/select queries on it from their own terminals (for instance, search for the product from a specified brand that had the max score on a certain test). Obviously, I could design a web interface or C# app that did this, but I'm sure there's a client side app already out there that would allow this as well.
So is there? Even like a free Microsoft downloadable perhaps? I guess what I'm really looking for is a query builder of sorts. I remember working with Access back in the day and it had a nice GUI for making up nice little queries with max/min/average options and fitlers aplenty; that's what I'm looking for.
Also, table management (a la PHPMyAdmin) would be nice, but isn't necessary. The primary thing my team members need to be able to do is run select queries like the example I gave in the first paragraph. They don't even need to do insertions necessarily because I have a separate system set up for that.
Thanks!
P.S. I found Acitve QueryBuilder and DbVisualizer through Google, and they both look great. However, they both cost money as well. Is there a free alternative? Or, if not, are these two I found good query builders? Or are there other ones that are better?
Update: I just realized that while I can't install SQL Server Developer on all my team members' terminals, I can install the Express edition, which includes the management studio. I'm new to the software, but I'll mess around with that and see if it does what I want and post back...
发布评论
评论（2）
您自己回答：SQL Management Studio Express Edition 是完成这项工作的正确工具。 然后，如果您需要限制某些访问，请使用与 DBO 相同的工具，并创建您需要的登录名，并对项目中涉及的数据库或对象进行特定的访问限制。
只是一个细节，使用 SQL Management Studio Express Edition，您无法操作大于 1 GB 的数据库的备份或副本。
You answered yourself: SQL Management Studio Express Edition is the right tool for the job. Then if you need to restrict some access use the same tool as DBO and create the logins you need with the specific access restrictions to databases or objects involved in the project.
Just one detail, with SQL Management Studio Express Edition you cannot manipulate backups or copies of a database larger than 1 Gigabyte.
您可以在他们的计算机上仅安装 Management Studio，而无需安装 SQL 引擎。 下载地址为 此处。
You can install just Management Studio on their machines without having to install the SQL Engine. The download for it is here.