发布网友
共1个回答
热心网友
insert
into
[a].dbo.[c]
select
*
from
[b].dbo.[d]
where
[a].dbo.[c].keyfield
not
in
(selec
keyfield
from
[b].dbo.[d]
)
关键字一个字段时用
若是我关健字是多个字段组成,不如先放到临时表中,然后删除冲突的,再导进C表