Microsoft Visual Studio中的SQL与SQL管理工作室之间的区别 [英] Difference between SQL inside Microsoft visual studio and SQL management studio

问题描述

先生，我是asp.net的初学者。我怀疑sql server management studio和microsoft visual studio里面的sql有什么区别。因为我的第一个项目是在软件内部做的。但我的第二个项目是在sql管理工作室，它是在线项目。你能告诉我吗？ PLZ



我尝试了什么：



先生，我是初学者在asp.net中。我怀疑sql server management studio和microsoft visual studio里面的sql有什么区别。因为我的第一个项目是在软件内部做的。但我的第二个项目是在sql管理工作室，它是在线项目。你能告诉我吗？ plz

sir,iam the beginner in asp.net. i have doubt that what is the difference between sql server management studio and sql inside microsoft visual studio. becaz my first project did inside software. but my second project didi in sql management studio and it was online project. can you tell me? plz

What I have tried:

sir,iam the beginner in asp.net. i have doubt that what is the difference between sql server management studio and sql inside microsoft visual studio. becaz my first project did inside software. but my second project didi in sql management studio and it was online project. can you tell me? plz

推荐答案

如果我正确理解了这个问题，那么SQL语句基本相同。数据库中的想法是使用SQL语言与数据库进行通信，数据库为您提供答案。您使用的工具可能会导致语句生成方式的差异，但SQL通常是相同的。



例如在Management Studio中，您可以编写查询

If I understand the question correctly the SQL statements are basically the same. The idea in databases is that you communicate with the database using SQL language and the database gives you and answer. The tool you use may cause differences on how the statement is generated but often the SQL is the same.

For example in Management Studio you could write a query

SELECT * FROM MyTable

并获得结果。在Visual Studio中，您可以使用表浏览器查看表中的行，因此您可能根本看不到SQL语句，但Visual Studio将使用类似的查询来获取数据。



使用Visual Studio创建的程序是什么，同样，SQL的创建方式也有所不同。您可以使用SqlCommand并自己编写，您可以使用Entity Framework并让它生成语句等。但在大多数情况下，SQL是发送到数据库的内容。

and get the results. In Visual Studio you could use a table browser to see rows inside a table so you may not see the SQL statement at all but Visual Studio would use a similar query to fetch the data.

What comes to programs you create using Visual Studio, again there are differences how the SQL is created. You can use SqlCommand and write it yourself, you can use Entity Framework and let it generate the statements and so on. But in most of the cases SQL is what is sent to the database.

这不是我们真正能够回答的问题，至少不是与你相关的术语。 />
问题是这两个应用程序是完全不同的，虽然Visual Studio有一些与SSMS重叠的数据库管理元素，但重叠可能不是你所说的。

VS的主要工作是允许您编写代码 - 可能使用也可能不使用数据库。

SSMS的主要工作是配置，管理和管理Microsoft SQL Server实例，与数据库管理和创建的环境一起。

这些重叠在一定程度上，SSMS的一些数据库创建和管理功能可以在VS内完成，VS的任何应用程序生成功能都不能在SSMS内完成。



因此要生成一个随时可用的应用程序作为你的项目，你需要VS.但是为了生成一个随时可用的数据库，你可以想象使用它们。



就个人而言，我主要使用SSMS来完成我的所有数据库工作，并且很少使用VS.数据库设施直接因为我发现它们比较笨拙和笨拙。我编写代码来访问VS中的数据库！

This isn't a question we can really answer, at least not in terms that are relevant to you.
The problem is that the two applications are completely different, and while Visual Studio has some elements of DB management which overlap with SSMS, that overlap probably isn;t what you are talking about.
The primary job of VS is to allow you to write code - which may or may not use a database.
The primary job of SSMS is to configure, manage and administer instances of Microsoft SQL Server, together with an environment for Database management and creation.
These overlap to an extent in that some of the database creation and management functions of SSMS can be done within VS, none of the application generation functions of VS can be done within SSMS.

So to produce a "ready to use" application as your project, you would need VS. But to produce a "ready for use" database, you could conceivably use either.

Personally, I mostly use SSMS for all my DB work, and rarely use the VS DB facilities directly as I find them clumsy and awkward in comparison. And I write my code to access the DB in VS!

这篇关于Microsoft Visual Studio中的SQL与SQL管理工作室之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！