摘要: godeclare @tbname varchar(250)declare #tb cursor for select name from sysobjects where objectproperty(id,'IsUserTable')=1open #tbfetch next from #tb into @tbnamewhile @@fetch_status=0beginexec('drop table ['+@tbname+']')fetch next from #tb into @tbnameendclose #tbdeallocate # 阅读全文
posted @ 2013-11-02 23:26 microsoftzhcn 阅读(362) 评论(0) 推荐(0) 编辑