如何判断sql数据表中是否更新
现在想判断数据库中的数据表是否更新，有什么办法吗？
[解决办法]
建一个表保存表里的记录数,每次查询完以后更新这个表
create table jl(tbname char (20),rows int )
truncate table jl
insert into jl
SELECTTOP100 Percent
sysobjects.name,
sysindexes.rows
FROMsysindexes with(nolock)
JOINsysobjects with(nolock)
ONsysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'
WHEREsysindexes.indid in(0, 1)
select a.*,b.*
from jl a,(SELECTTOP100 Percent
sysobjects.name,
sysindexes.rows
FROMsysindexes with(nolock)
JOINsysobjects with(nolock)
ONsysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'
WHEREsysindexes.indid in(0, 1) ) b
where a.tbname=b.name and a.rows<>b.rows and b.name<>'jl'
