Posts by Gabriel Oliveira Almeida • 23 points

• 1

  votes

  2

  answers

  801

  views

  A: 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…

  sql sql-server join sql-update

  answered 6 years ago Gabriel Oliveira Almeida 23

• 1

  votes

  2

  answers

  801

  views

  Q: 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…

  sql sql-server join sql-update

  asked 6 years ago Gabriel Oliveira Almeida 23