摘要: declare @procName varchar(500)declare cur cursorfor select [name] from sys.objects where type = 'p'open curfetch next from cur into @procNamewhile @@fetch_status = 0beginif @procName <> 'DeleteAllProcedures'exec('drop procedure ' + @procName)fetch next from cur into @pr 阅读全文
posted @ 2011-08-16 15:00 张宏宇 阅读(214) 评论(0) 推荐(0) 编辑