Answers for "update openquery"

SQL
0

update all linkedserver tables with openquery on db

UPDATE a 
SET    a.MMDWNO = '21'
FROM   OPENQUERY(NMIIFLIB,
       'select * from MVXCDTANSN.MITMAS WHERE MMITTY = ''25''') a
Posted by: Guest on July-15-2020
0

update all linkedserver tables with openquery on db

UPDATE OPENQUERY(NMIIFLIB, 'select * from MVXCDTANSN.MITMAS where MMITTY = ''25''')
SET MMDWNO = 21
Posted by: Guest on July-15-2020

Code answers related to "update openquery"

Code answers related to "SQL"

Browse Popular Code Answers by Language