Q:
Create Stored Procedure based upon existing Stored Procedure
How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760
ASKED:
Sep 8 2008 6:31 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
