update sql relating a column with external value

Question

Good morning, I’m having a hard time updating SQL Server. I have the following situation:

Table 1

ID
Codigo

Table 2

ID
Nome

And I have an excel file like this:

Excel

Codigo
Nome

I need to update the column Name of Table 2, with the data of excel, what would be querry in that situation?

I tried that:

SELECT *
FROM Tabela2 F
FULL JOIN Tabela1 M ON F.id = M.codigo

Answer 1

I managed with the following situation

update Tabela 2
set Nome = '**NOME**'
from Tabela 2 A
INNER JOIN Tabela 1 B on B.ID = A.id
where B.Codigo = '**CODIGO**'

As the values are in an excel file I need to update a situation in an SQL table, I will need to manually make this querry for every update I need to update. The values NAME, CODE are in excel. By excel itself I can make a structure of CONCATENATE, which will kind of prepare the querrys. Thanks for the tips, and for the attention!

Answer 2

I think you’re looking for inner join:

SELECT T2.Nome,
       T1.Codigo
FROM Table1 T1 INNER JOIN Table2 T2 ON T1.ID = T2.ID
WHERE --outras condições

To insert the excel file data:

SELECT * INTO nome do arquivo
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
    'Excel 12.0; Database=nome do arquivo.xlsx', [página$]);

If you are looking for an update when joining the two tables:

UPDATE T2
SET Nome = 'NOME'
FROM [Tabela 2] T2
INNER JOIN [Tabela 1] T1 on T2.ID = T1.id
WHERE T2.Codigo = 'CODIGO'