34,594
社区成员
发帖
与我相关
我的任务
分享
如果要算bds(text)这列,先转换为varchar
select * from (select id , ..., cast(bds as varchar) from a) m where checksum(*) not in (select checksum(*) from (select id , ..., cast(bds as varchar) from a) n )
--前提:表中不能有text、ntext、image、cursor 数据类型的字段。
用CheckSum()最简单:
select * from A where checksum(*) not in (select checksum(*) from B)
select * from tb where checksum(*) not in(select checksum(*) from ta)