22,301
社区成员




应该是删除数据.
--前提:表中不能有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