[quote=引用 1 楼 吉普赛的歌 的回复:] 先在 B 上创建指向 A 的链接服务器: https://blog.csdn.net/yenange/article/details/9456145 SQL大致是这样: insert into targetDb.dbo.targetTableName(c1,c2) select c1,c2 from linkedServerA.dbo.sourceTableName as A where not exists( select 1 from targetDb.dbo.targetTableName as B where A.id=B.id )
insert into targetDb.dbo.targetTableName(c1,c2) select c1,c2 from linkedServerA.dbo.sourceTableName as A where not exists( select 1 from targetDb.dbo.targetTableName as B where A.id=B.id )
先在 B 上创建指向 A 的链接服务器: https://blog.csdn.net/yenange/article/details/9456145 SQL大致是这样: insert into targetDb.dbo.targetTableName(c1,c2) select c1,c2 from linkedServerA.dbo.sourceTableName as A where not exists( select 1 from targetDb.dbo.targetTableName as B where A.id=B.id )
27,579
社区成员
68,558
社区内容
加载中
试试用AI创作助手写篇文章吧