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.
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