建一个表保存表里的记录数,每次查询完以后更新这个表 create table jl(tbname char (20),rows int ) truncate table jl insert into jl SELECT TOP 100 Percent sysobjects.name, sysindexes.rows FROM sysindexes with(nolock) JOIN sysobjects with(nolock) ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u' WHERE sysindexes.indid in(0, 1) select a.*,b.* from jl a,(SELECT TOP 100 Percent sysobjects.name, sysindexes.rows FROM sysindexes with(nolock) JOIN sysobjects with(nolock) ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u' WHERE sysindexes.indid in(0, 1) ) b where a.tbname=b.name and a.rows<>b.rows and b.name<>'jl'
create table jl(tbname char (20),rows int )
truncate table jl
insert into jl
SELECT TOP 100 Percent
sysobjects.name,
sysindexes.rows
FROM sysindexes with(nolock)
JOIN sysobjects with(nolock)
ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'
WHERE sysindexes.indid in(0, 1) select a.*,b.*
from jl a,(SELECT TOP 100 Percent
sysobjects.name,
sysindexes.rows
FROM sysindexes with(nolock)
JOIN sysobjects with(nolock)
ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'
WHERE sysindexes.indid in(0, 1) ) b
where a.tbname=b.name and a.rows<>b.rows and b.name<>'jl'
如果表少的话,给表加个INSERT,UPDATE,DELETE触发器,有触发,则算一次更新
select name,modify_date from sys.all_objects where type='U'