Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to alter a stored procedure in a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 19:39:13
finch writes "I have a sp_dosomething stored procedure, in which there is a sentence like this:
declare @eventid int
set @eventId=
case @somethingtype
when 1 then 1
when 2 then 2
when 3 then 3
when 4 then 4
end
and I want to alter this sp by add more "when .. then.." in another sp_addnewsomething. Could you please help me?"
   

- Advertisement -