08 2011 档案

删除数据库中所用户创建的存储过程SQL
摘要：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 张宏宇 阅读(219) 评论(0) 推荐(0)