Posted on

Update linked server table based on local table – Database Administrators Stack Exchange

1 down vote accepted You cant have 5 identifiers, this should do the trick UPDATE T2 SET T2.cod = T1.codigo FROM [HQSQLHOM01\SQLHOM01].dba_teste.dbo.tabela2 AS T2 JOIN tabela1 AS T1 ON T1.id = T2.id https://technet.microsoft.com/en-us/library/ms190406(v=sql.105).aspx shareimprove this answer

Source: Update linked server table based on local table – Database Administrators Stack Exchange

Leave a Reply

Your email address will not be published. Required fields are marked *