Xarzu (10/13/2010)
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.
VS2010 contains Object Explorer. If you are using database project then go to schema editor/viewer and drip down to stored procedure folder. Right click -> add new stored procedure -> type stored proc name & add your code.
Thanks