时间戳

--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]'

转载于:https://www.cnblogs.com/zhouzhou-aspnet/p/3844491.html