数据库|mysql教程
存储过程
数据库-mysql教程
3d字体源码怎么用,ubuntu没有启动选项,夏天出现的爬虫,php 输出.,根词seolzw
sqlserver 批量删除存储过程和批量修改存储过程的语句，需要的朋友可以参考下。
浮云网发货网站源码,vscode输入中文识别代码,ubuntu 获取ip,tomcat临时文件,单词sqlite,网页设计返回首页,阿里云服务器安装数据库,服务器 1元开通,省市区联动的js插件,前端ui框架还有必要出效果图吗,皮炎爬虫,mysql和php,网络推广seo是什么,springboot+oa,dedecms织梦怎么添加自定义属性标签,网站短信代码,图片怎么使用网页代码,win8 html模板,dede后台上传视频,产品筛选页面开发,毕业生管理系统源代码,如何开发斗地主程序lzw
资讯论坛源码,惠普 ubuntu双系统,下截了tomcat怎么安装,家里多条腿爬虫,php入门教程全局标签外包,广州 seo工资lzw
修改：
代码如下:
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 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 + ‘已被修改’)
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
