openquery - How to update a SQL Server table with updated Oracle table Data - Stack Overflow

PHOTO EMBED

Fri Jan 21 2022 22:30:07 GMT+0000 (UTC)

Saved by @jwspid24 #sql

UPDATE MS 
    SET    MS.NAME = OC.NAME
    FROM   OPENQUERY(WZ12,
      'select EMP, NAME from Test') OC 
   INNER JOIN [dbo].[TEST1] MS 
     ON OC.EMP = MS.EMP
content_copyCOPY

https://stackoverflow.com/questions/54873585/how-to-update-a-sql-server-table-with-updated-oracle-table-data