sqlserver 批量删除存储过程和批量修改存储过程的语句
发布时间:2021-12-24 09:45:43 所属栏目:MsSql教程 来源:互联网
导读:修改: 复制代码 代码如下: 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
修改: 复制代码 代码如下: 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 (编辑:大连站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- sql-server – 当主表更新时,外键是否自动更新?
- sql 中rand函数怎样用?sql怎样获取区间随机数?
- sql-server – 使用WITH REPLACE恢复备份时出现错误3154
- 数据库 – 通过http和json同步2个sqlite表的最好方法是什么
- sql – 查找值并显示找到的值的数据库,表,列,主键
- sql-server – 无法在计算列上创建筛选索引
- sql-server-2008 – 在EF4中控制ArithAbort
- SQL Server存储过程以发送电子邮件
- sql-server – 使用带有nHibernate的CreateSQLQuery的SQL S
- sql-server – 我可以在SQL R2服务器中创建SQL v10.0数据库
站长推荐
热点阅读