批量删除表
摘要：
CREATEPROCEDUREdropTable@tableNamevarchar(40)ASdeclarecurcursorread_onlyforselectdistincttable_namefrominformation_schema.columnswheretable_namelike@tableNamedeclare@namevarchar(40),@sqlvarchar(1000)opencurfetchnextfromcurinto@namewhile(@@fetch_status=0)beginset@sql='droptable'+@nameexec(@sq 阅读全文
posted @ 2011-03-08 10:53 项羽 阅读(226) 评论(0) 推荐(1) 编辑