What is "query writer, new querry in sql server management studio express

Question

using :- sql servr 05 and vs08 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=@input etc

please provide links to tutorials which explain how to use sql server studio and vs 08 together i searched the net but cannot find the answer

thankyou

Answer 1

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.

Answer 2

check this question of mine

good answer there

"Made this query in SQL Server Management Studio Express how to use it?"

high points user please close this post,

cannot deleted it as upvoted answer