SQL Server:openquery插入链接的服务器 [英] SQL Server : openquery insert linked server

问题描述

如何在不存在行的情况下将数据插入到链接服务器(oracle)中?

How do I insert data into a linked server (oracle) with a condition that a row does not exist?

如果该表中还不存在employeecode，我想插入到employee表中

I want to insert into employee table if employeecode does not exist yet in that table

INSERT INTO OPENQUERY(ORACLEX,
  'SELECT EMPCODE, EMPNAME FROM AX.EMPLOYEE') -- I want a where clause here

Select EID, ENAME FROM EMPDATA

推荐答案

您实际上可能不得不从表中读取两次

You might actually have to read from the table twice

   INSERT INTO OPENQUERY(ORACLEX,
  'SELECT EMPCODE, EMPNAME FROM AX.EMPLOYEE') -- I want a where clause here
   Select D.EID, D.ENAME
     FROM EMPDATA D
LEFT JOIN OPENQUERY(ORACLEX,
  'SELECT EMPCODE, EMPNAME FROM AX.EMPLOYEE') OQ ON OQ.EMPCODE = D.EID
    WHERE QQ.EMPCODE IS NULL;

这篇关于SQL Server:openquery插入链接的服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！