導讀:1建站知識sqlserver 批量刪除存儲過程和批量修改存儲過程的語句，需要的朋友可以參考下。建設網站公司網站建設教程。

修seo網站排名優化軟件改：

復制代碼 代碼如下:

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 + '已被刪除') fetch next from proccur in企業網站建設to @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 + '已被修改') fetch next from proccur into @procname end close proccur deallocate proccur

復制代碼 代碼如下:

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 + '已被刪除') fetch next from proccur into @procname end close proccur deallocate proccur

關鍵詞標簽: 批量 存儲過程