T-SQL中CHECKSUM函数的用法

declare @t table(a nvarchar(50),b int,c datetime)
insert into @t select '',1,cast('2023-06-27 16:25:14.583' as datetime)

declare @s table(a nvarchar(50),b int,c datetime)
insert into @s select null,1,cast('2023-06-27 00:00:00.000' as datetime)

--不同
select case when CHECKSUM(t.a,t.c)=checksum(s.a,s.c) then '相同' else '不同' end as ty
from @t t inner join @s s on t.b=s.b

--格式化：相同
select case when CHECKSUM(t.a,convert(nvarchar(10),t.c,120))=checksum(isnull(s.a,''),convert(nvarchar(10),s.c,120)) then '相同' else '不同' end as ty
from @t t inner join @s s on t.b=s.b