--时间戳类型和bigint互相转化示例:
set nocount on
--申明3个时间戳
declare @timeFlag1 bigint
declare @timeFlag2 bigint
declare @timeFlag3 bigint
--建立表,timestamp类型不需要字段名
create table test(timestamp,a int)
--插入1 记录时间戳,@@dbts为数据库时间戳
insert into test select null,1
set @timeFlag1=cast(@@dbts as bigint)
--插入2 记录时间戳
insert into test select null,2
set @timeFlag2=cast(@@dbts as bigint)
--更新3 记录时间戳
update test set a=3 where a=2
set @timeFlag3=cast(@@dbts as bigint)
--时间戳1的记录
select *from test where timestamp=cast(@timeFlag1 as varbinary(8))
--时间戳2的记录已经不存在了
select *from test where timestamp=cast(@timeFlag2 as varbinary(8))
--时间戳3的记录
select *from test where timestamp=cast(@timeFlag3 as varbinary(8))
set nocount on
--申明3个时间戳
declare @timeFlag1 bigint
declare @timeFlag2 bigint
declare @timeFlag3 bigint
--建立表,timestamp类型不需要字段名
create table test(timestamp,a int)
--插入1 记录时间戳,@@dbts为数据库时间戳
insert into test select null,1
set @timeFlag1=cast(@@dbts as bigint)
--插入2 记录时间戳
insert into test select null,2
set @timeFlag2=cast(@@dbts as bigint)
--更新3 记录时间戳
update test set a=3 where a=2
set @timeFlag3=cast(@@dbts as bigint)
--时间戳1的记录
select *from test where timestamp=cast(@timeFlag1 as varbinary(8))
--时间戳2的记录已经不存在了
select *from test where timestamp=cast(@timeFlag2 as varbinary(8))
--时间戳3的记录
select *from test where timestamp=cast(@timeFlag3 as varbinary(8))
为系统而生,为框架而死,为debug奋斗一辈子;
吃符号的亏,上大小写的当,最后死在需求上。