How do you create stored procedures in SQL Server 2000?
How do you create stored procedures in SQL Server 2000?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 1, 2009 7:18 PM
UPDATED:
May 15, 2009 4:55 AM
RELATED QUESTIONS
- Changes in stored procedures from SQL Server 2000 to SQL Server 2005
- Migrating stored procedures from SQL Server 2000 to 2005
- Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
- Create Excel file on web server by using SQL
- Viewing created stored procedures in SQL Server
Answer Wiki:
Dont think much ... Open Query Analise and press F1 :)
Search for CREATE PROCEDURE
Got it ....
Njoy
----
Take the SQL Statement that you want to make the stored procedure and put the below line above it. Then run the script. This will create a stored procedure based on the name you provided in the database.
<pre>CREATE PROCEDURE <i>YourProcedureName</i> AS</pre>
You should also read my blog entry on <a href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-stored-procedures-the-work-horse-of-the-database/">Stored Procedures</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
