Microsoft SQL Server Management Studio (2008) Question

Bill_Thompson · October 14th, 2010, 01:11 AM

I am new to writing stored procedures and this will be my first stored procedure written with Microsoft SQL Server Management Studio. I am familiar with working with VS 2010 and I have noticed that the IDE is very different. So, let's start with the basics. How do I go about adding a new stored procedure into the group of stores procedures that the project currently has. I already know that name and the T-SQL code I need. I just need to put it.

Jitender · October 14th, 2010, 01:31 AM

if you are using SqlCommand object then you use:
cmd.commandType = CommandType.StoreProcedure;

this is to call a store procedure

Bill_Thompson · October 14th, 2010, 02:00 AM

Quote:

Originally Posted by Jitender

if you are using SqlCommand object then you use:
cmd.commandType = CommandType.StoreProcedure;

this is to call a store procedure

How do I save it? I mean the stored procedure, not the C# code. In the Object Explorer of the SQL Manager there is already a list of stored procedures and I want my stored procedure in that list.

You see, I am accessing this stored procedure through a C# WPF user interface

r.kondapalli · October 14th, 2010, 03:56 AM

CREATE PROC <Stored Procedure name>
AS
<your query>