摘要:
--创建临时表create table #temp(Recordcount int ,tableName varchar(30))--用游标将查询的记录数,插入临时表declare @tablename varchar(30)declare @sql varchar(100)declare @str varchar(30)declare tablecursor cursor forselect name from sysobjects where xtype='u'open tablecursorfetch next from tablecursor into @tablena 阅读全文