SQL Server deletes stored procedures in batches and modifies stored procedures in batches. For more information, see.
SQL Server deletes stored procedures in batches and modifies stored procedures in batches. For more information, see.
Modify:
The 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:
The 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