I have to insert few values to a database table. For that I’m using assign activity to assign the values to required variables.
How can I insert variable values into database using run query activity.
Kindly help
I have to insert few values to a database table. For that I’m using assign activity to assign the values to required variables.
How can I insert variable values into database using run query activity.
Kindly help
For insert you need to use run non query and in the insert statement include variables
Cheers
Hi @Aarya_Sajeev ,
Database connect.docx (205.0 KB)
Pls check this doc for detailed connection of db and run query.
Inserting data to database requires couple of steps. Kindly follow the below steps and let us know where exactly you are facing challenge
For example, if you have variables for name and phone number, your SQL query might look like this:
"INSERT INTO YourTableName (NameColumn, PhoneColumn) VALUES ('" + nameVariable + "', '" + phoneVariable + "')"
This process allows you to insert variable values into a database table using the Run Query activity in UiPath