删除所有存储过程的sql语句

摘要： 2008-06-16 18:17来自dudu[code] 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 ' + @ 阅读全文
posted @ 2012-08-17 10:45 Tyler Wang 阅读(312) 评论(0) 推荐(0)