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 if @procName ‘DeleteAllProcedures’ exec(‘drop procedure ‘ + @p
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where ty本文来源gaodaimacom搞#^代%!码&网*pe = ‘p’
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
if @procName ‘DeleteAllProcedures’
exec(‘drop procedure ‘ + @procName)
fetch next from cur into @procName
end
close cur
deallocate cur
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：请问SQLSERVER2005如何删除所有存储过程
转载请注明原文链接：请问SQLSERVER2005如何删除所有存储过程
