Posts by Gabriel Oliveira Almeida • 23 points
2 posts
-
1
votes2
answers801
viewsA: update sql relating a column with external value
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…
-
1
votes2
answers801
viewsQ: update sql relating a column with external value
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…