how to “store” stored procedures

Question

I've written a few SQL stored procedures in a text editor. But how do I actually "store" them in (add them to?) a database using SQL Server 2008 Management Studio Express? I've tried to research this topic in Management Studio's onboard Help, but apparently Help assumes I know more about the subject than I actually do, because I don't even see the relevance of the answers I'm getting to my questions. Any help would be appreciated, including pointing me to a good SQL tutorial that assumes the reader knows nothing, yet teaches more than the bare-bones minimum.

Vijaya Kadiyala · Answer

Can you paste the source code of your stored procedure? Thanks -- Vijaya Kadiyala www.DotNetVJ.Com

Jan Montano · Answer

No, you don't have to associate a specific procedure to the table. you specify those details in the sql statement inside the stored proceduer itself like the statement SELECT firstname, lastname FROM employee

Bob Lewiston · Answer

Scott Lysle: Thanks for help. One question: don't I have to associate a procedure with a given table? Otherwise, how will the procedure recognize the column names?

Scott Lysle · Answer

You don't need to write them into a text editor; to add a stored procedure from the management studio, open the database, open the programmability folder, right click stored procedures, and select 'new stored procedure'. Since you have written them already, just replace the contents with your existing scripts. You can save the stored procedure by executing it. Once it has been added, you can modify it from the same location by right clicking it and selecting "modify".