删除所有存储过程的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语句
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) fetch next from cur into @procname endclose curdeallocate cur