34,588
社区成员
发帖
与我相关
我的任务
分享
begin tran
alter table tab_A nocheck constraint fk;
insert into tb_A(szNumber) values('03895678')
insert into tb_B(szNumber) values('03895678')
alter table tab_B check constraint fk
commit tran
把fk换成你表的外键名。INSERT INTO tb1
(
field1,field2
)
SELECT field1,field2 FROM tb2 b
WHERE not EXISTS
(
SELECT 1
FROM tb2 a
WHERE a.szNumber = b.szNumber
)
INSERT INTO tb2
(
field1,field2
)
SELECT field1,field2 FROM tb1 a
WHERE not EXISTS
(
SELECT 1
FROM tb2 b
WHERE a.szNumber = b.szNumber
)