Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Xarzu
Starting Member
25 Posts |
 Posted - 2010-10-14 : 00:54:51
|
| I am new to writing stored proecedures 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. |
|
|
matty
Posting Yak Master
161 Posts |
Posted - 2010-10-14 : 01:09:47
|
| Click on New Query. Write the stored procedure and Execute it. |
 |
|
|
Xarzu
Starting Member
25 Posts |
Posted - 2010-10-14 : 01:45:15
|
| No, that is now what I mean. How do I save it? In the Object Explorer, 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.All I am asking is this. How do I write and save a stored procedure in Microsoft SQL Server Management Studio for SQL Server 2008? |
|
|
|
matty
Posting Yak Master
161 Posts |
Posted - 2010-10-14 : 02:20:24
|
| Once a stored procedure is executed, it will list under Stored Procedures in Object Explorer.Just refresh and see. |
|
|
|
|
|
|
Microsoft SQL Server Management Studio Question