how to “store” stored procedures

Bob Lewiston

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala17y ago
Can you paste the source code of your stored procedure?

Thanks -- Vijaya Kadiyala

www.DotNetVJ.Com
Jan Montano17y ago
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 Lewiston17y ago
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 Lysle17y ago
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".