visual-studio 什么是 Microsoft SQL 服务器，为什么需要安装它？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2067820/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is Microsoft SQL server and why do I need to install it?
提问by Gordon Gustafson
All I want to install is visual web developer (but I've had this issue with other things like visual C# to), so when I choose to install just that from microsoft web platform, it wants to download that, under 3mb, and SQL server (dependency it says,) 100mb. I've seen lots of computers with SQL server installed, does it come with all windows distributions? Do many other applications use it to work? Should I just install it if part of visual studio wants me to? When it asks me to make an administrator account and password for it, should I just type in whatever to get it to install as I won't be using it directly?
我想要安装的只是visual web developer（但我在visual C#之类的其他东西上遇到了这个问题），所以当我选择从microsoft web platform安装它时，它想下载3mb以下的，和SQL服务器（它说的依赖性）100mb。我见过很多安装了 SQL Server 的计算机，它是否随所有 Windows 发行版一起提供？许多其他应用程序使用它来工作吗？如果视觉工作室的一部分需要我安装它，我应该安装它吗？当它要求我为其创建管理员帐户和密码时，我是否应该输入任何内容来安装它，因为我不会直接使用它？
回答by Robert Harvey
What is it?
它是什么？
It is a database system.
它是一个数据库系统。
does it come with all windows distributions?
它是否与所有 Windows 发行版一起提供？
No.
不。
Do many other applications use it to work?
许多其他应用程序使用它来工作吗？
Yes.
是的。
Should I just install it if part of visual studio wants me to?
如果视觉工作室的一部分需要我安装它，我应该安装它吗？
Yes. It will hook everything up for you to a copy of SQL Server Express, so no further configuration will be required to make it work.
是的。它会将您的所有内容连接到SQL Server Express的副本，因此无需进一步配置即可使其工作。
When it asks me to make an administrator account and password for it, should I just type in whatever to get it to install as I won't be using it directly?
当它要求我为其创建管理员帐户和密码时，我是否应该输入任何内容来安装它，因为我不会直接使用它？
Yes. Remember the user name and password for later use, but you will probably be using Windows Authentication to access SQL Server on your own machine, so you won't need this user name and password on a regular basis.
是的。记住用户名和密码以备后用，但您可能会使用 Windows 身份验证来访问您自己机器上的 SQL Server，因此您不会经常需要此用户名和密码。
回答by AaronLS
The reason it is installed along with Visual Studio is because SQL Server is a database system for storing data, and many developers these days are writing applications that work with databases, so the developer often needs a SQL Server installed so that he has a database system to develop and test against. So in a nutshell, if you were writing such an application, you would already know what it is, and would know that you need it. Which is why OrbMan said "If you don't know what it is, you don't need it."
和 Visual Studio 一起安装的原因是因为 SQL Server 是一个用于存储数据的数据库系统，现在很多开发人员都在编写处理数据库的应用程序，所以开发人员经常需要安装一个 SQL Server 以便他有一个数据库系统开发和测试。所以简而言之，如果您正在编写这样的应用程序，您就会知道它是什么，并且知道您需要它。这就是为什么 OrbMan 说“如果你不知道它是什么，你就不需要它。”
If you get in the mood to learn something new though, I would highly recommend reading about SQL and SQL Server. It is used alot in the real world.
如果您有心情学习新的东西，我强烈建议您阅读有关 SQL 和 SQL Server 的内容。它在现实世界中被大量使用。
