20 pts. Create Stored Procedure based upon existing Stored Procedure
Stored Procedures, SQL Query Analyzer, SQL Query Analyzer 8.x
How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760 Question
Stored Procedures, SQL Query Analyzer, SQL Query Analyzer 8.x
How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Is the following correct?
1. Right click existing stored procedure
2. Select 'Edit''
3. Change 'Alter' to 'Create'
4. Change existing name of Procedure to new name of Procedure
5. Change existing name of Procedure to the right of 'Exec' to the new name of procedure.
6.Then make changes as needed.
Browse more Questions and Answers on SQL Server.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
