什么是“查询编写器”，SQL Server Management Studio Express 中的新查询
使用：SQL Server 2005 和 Visual Studio 2008、C# 网站 asp.net
好的，我一直使用 SQL Server 2005 Express 及其 Management Studio 作为主机和设计界面，仅从设计视图创建表。
网站运行时所需的所有查询、事务、检索和任何操作都是使用 Visual Studio 2008 sql 完成的“连接打开，然后形成命令语句，并执行阅读器等，这一切都是使用 Visual Studio 08 c# 完成的”
所以我想知道SQL Server Management Studio Express 中有一个查询编写器。
它是做什么用的？
- 它可以用来代替 vs08 c# 查询吗？
- 如何从 C# 网站调用它？
- 它可以用于变量查询，如
where id = @input等
请提供教程链接，解释如何一起使用 SQL Server studio 和 Visual Studio 2008 我在网上搜索但找不到答案
Using: SQL Server 2005 and Visual Studio 2008, C# website asp.net
Okay, I have always used SQL Server 2005 Express and its Management Studio as a host and a design interface to create tables from design view only.
All the queries, transaction, retrieval and anything needed during run time of the website is done using Visual Studio 2008 sql "connection open, then form command statement, and execute reader etc its all done using Visual Studio 08 c#"
So I was wondering that there is a query writer thing in SQL Server Management Studio Express.
What is it for ?
- can it be used in place of vs08 c# queries?
- how to call it from web sites c#?
- can it use for variables queries like
where id = @inputetc
Please provide links to tutorials which explain how to use SQL Server studio and Visual Studio 2008 together I searched the net but cannot find the answer
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以使用查询编写器编写您只想立即使用的查询，而不是设置一个网站来一遍又一遍地运行查询。您还可以使用它来创建称为存储过程的东西，然后可以从您的网站调用它。不过，我相信，如果您愿意，您可以使用 Visual Studio 完成这两件事。存储过程可以接受输入变量，这样非常有用。就我个人而言，我喜欢它们。不是每个人都这样做。如果您使用 Command 对象从 C# 调用它们，您可能需要将该对象的 .CommandType 属性更改为 StoredProcedure。
You can use the query writer to write queries that you only want to use right then, instead of setting up a web site to run queries over and over again. You can also use it to create something called stored procedures, which you can then call from your web site. However, if you want, you can do both of those things with Visual Studio, I believe. Stored procedures can accept input variables, and are very useful that way. Personally, I like them. Not everyone does. If you call them from C# with a Command object, you probably need to change the .CommandType property of the object to StoredProcedure.