22,207
社区成员
发帖
与我相关
我的任务
分享
应该是删除数据.
--前提:表中不能有text、ntext、image、cursor 数据类型的字段。
用CheckSum()最简单:
--查询
select * from A where checksum(*) not in (select checksum(*) from B)
select * from B where checksum(*) not in (select checksum(*) from A)
--删除
select * into c from A where checksum(*) not in (select checksum(*) from B)
delete * from A where checksum(*) not in (select checksum(*) from C)
delete * from B where checksum(*) not in (select checksum(*) from C)
drop table c