22,209
社区成员
发帖
与我相关
我的任务
分享
if object_id('tempdb.dbo.#') is not null drop table #
create table # (id int, ufts timestamp)
insert #(id) select 1
select id, ufts, str_ufts=master.dbo.fn_varbintohexstr(ufts) from #
/*
id ufts str_ufts
----------- ------------------ ------------------
1 0x00000000000007D1 0x00000000000007d2
*/
if object_id('tempdb.dbo.#') is not null drop table #
create table # (id int, ufts timestamp)
insert #(id) select 1
select id, ufts, str_ufts=dbo.fn_varbintohexstr(ufts) from #
/*
id ufts str_ufts
----------- ------------------ ------------------
1 0x00000000000007D1 0x00000000000007d1
*/