查询大表数据
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.xtype='U' and i.indid<2 and i.rows>3000
order by i.rows DESC
use [database_name]
delete from [table_name]
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.xtype='U' and i.indid<2 and i.rows>3000
order by i.rows DESC
use [database_name]
delete from [table_name]
