删除所有存储过程

来源：动视网责编：小采时间：2020-11-09 16:13:29

删除所有存储过程

删除所有存储过程:删除所有存储过程的sql语句无 DECLARE @procName VARCHAR(500)DECLARE cur CURSOR FOR SELECT [name] FROM sys.objects WHERE type = 'p'OPEN curFETCH next FROM cur INTO @procNameWHILE @@fetch_s

推荐度：

点击下载本文 文档为doc格式

导读删除所有存储过程:删除所有存储过程的sql语句无 DECLARE @procName VARCHAR(500)DECLARE cur CURSOR FOR SELECT [name] FROM sys.objects WHERE type = 'p'OPEN curFETCH next FROM cur INTO @procNameWHILE @@fetch_s

删除所有存储过程的sql语句无 DECLARE @procName VARCHAR(500)DECLARE cur CURSOR FOR SELECT [name] FROM sys.objects WHERE type = 'p'OPEN curFETCH next FROM cur INTO @procNameWHILE @@fetch_status = 0 BEGIN EXEC('drop procedure ' + @procName) FE

删除所有存储过程的sql语句
<无> $velocityCount-->

 DECLARE @procName VARCHAR(500)
DECLARE cur CURSOR FOR
 SELECT [name]
 FROM sys.objects
 WHERE type = 'p'

OPEN cur

FETCH next FROM cur INTO @procName

WHILE @@fetch_status = 0
 BEGIN
 EXEC('drop procedure ' + @procName)

 FETCH next FROM cur INTO @procName
 END

CLOSE cur

DEALLOCATE cur

删除所有存储过程

推荐度：

点击下载本文 文档为doc格式

标签：删除批量删除过程

热门焦点

删除所有存储过程

删除所有存储过程

删除所有存储过程

最新推荐

猜你喜欢

热门推荐