SQL Server deletes stored procedures in batches and modifies stored procedures in batches

Modify:
Copy codeThe Code is as follows:
Declare proccur cursor
For
Select [name] from sysobjects where name like 'Foods _ %'
Declare @ procname varchar (100)
Declare @ temp varchar (100)
Open proccur
Fetch next from proccur into @ procname
While (@ FETCH_STATUS = 0)
Begin
Set @ temp = 'kcb _ '+ @ procname
EXEC SP_RENAME @ procname, @ temp

Print (@ procname + 'deleted ')
Fetch next from proccur into @ procname
End
Close proccur
Deallocate proccur

Declare proccur cursor
For
Select [name] from sysobjects where name like 'kcb %'
Declare @ procname varchar (100)
Declare @ temp varchar (100)
Declare @ temp2 varchar (100)
Declare @ temp3 varchar (100)
Open proccur
Fetch next from proccur into @ procname
While (@ FETCH_STATUS = 0)
Begin
Set @ temp3 = LEN (@ procname)
Set @ temp = 'kcb _'
Set @ temp2 = RIGHT (@ procname, @ temp3-3)
Set @ temp + = @ temp2
EXEC SP_RENAME @ procname, @ temp

Print (@ procname + 'Modified ')
Fetch next from proccur into @ procname
End
Close proccur
Deallocate proccur

Delete:
Copy codeThe Code is as follows:
Declare proccur cursor
For
Select [name] from sysobjects where name like 'users _ %'
Declare @ procname varchar (100)
Open proccur
Fetch next from proccur into @ procname
While (@ FETCH_STATUS = 0)
Begin
Exec ('drop proc' + @ procname)
Print (@ procname + 'deleted ')
Fetch next from proccur into @ procname
End
Close proccur
Deallocate proccur