Hello, I needed to update the data in the table I’ve already entered in SQL databse. The columns name in the table called Inv_DT are: • invoice_key (primary key) • company_code (primary key) • amount • status If primary keys match (allreday stored in SQL vs. new data), the robot will update t…

Update table query in SQL databse

TimK (Tim Kok) January 24, 2019, 4:18pm 2

Are you looking for a SQL statement to update the Inv_DT?

If so, it wold be good to look at SQL_Update

Once you have your base statement, you can then add your variables for invoice_key and company_code as this link Using Parameters in Non-Query

Hope that helps

Topic		Replies	Views
Updating SQL database Activities datatable , excel , studio	2	738	February 8, 2021
Adding column using Alter statement in Excel as a Database Help excel , database , activities , error	3	1279	July 18, 2022
Update MS SQL DB using Data table as Parameter Help database , activities	2	1923	February 20, 2019
Upgrade SQL datatable Help	5	1499	October 29, 2018
Update SQL COLUMN Help database , activities , question	3	959	November 5, 2019