--drop table [t11] CREATE TABLE [dbo].[t11]( [a] [int] NOT NULL, ok timestamp ) --drop table config create table config( tablename varchar(50) not null, ok binary(8) ) GO insert into t11(a) values(1) insert into t11(a) values(2) --读取数据(第一次) select * from t11 --保存最大时间 insert into config(tablename,ok) SELECT '[dbo].[t11]',MAX(ok) FROM [dbo].[t11] ----------------------我是分割线------------------------- --新增 insert into t11(a) values(3) --读取数据(后续) select a,cast([ok] as datetime), ok from t11 where ok>(select ok from config where tablename ='[dbo].[t11]') --更新时间戳 update config set ok=(SELECT MAX(ok) FROM [dbo].[t11]) where tablename ='[dbo].[t11]'