Home > IT Answers > SQL Server > How do you create stored procedures in SQL Se...
SQL Server Ask the Experts
2435 pts.
0
Q:
How do you create stored procedures in SQL Server 2000?
SQL Server 2000, SQL Server stored procedures
How do you create stored procedures in SQL Server 2000?
ASKED: May 1 2009  7:18 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
AshishAmodia
20 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button

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.

CREATE PROCEDURE YourProcedureName AS


You should also read my blog entry on Stored Procedures.
Last Answered: May 15 2009  4:55 AM GMT by AshishAmodia   20 pts.
Latest Contributors: Mrdenny   47055 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0