SQL - command Insert into

Hello guys, I have a datatable with 3 columns. “id”, “name”, “phone”. How do I insert this data into sql using insert into. I want to make this insertion dynamically. Can I put a variable inside the insert into?

tkx!

Yah that’s possible like this
"INSERT Into SqlDataTable (Column1,Column2,Column3) values (@variable1,@variable2,@variable3)"

Where we need to install UiPath.Database.Activities package from design tab -> Manage Packages -> Official tab -> search for above package and install it

—and once after installing use EXECUTE QUERY activity and mention the aBove expression with variables in it

Cheers @mauro.morais

2 Likes

Hi @Palaniyappan , I couldn’t solve it. I am sending my code, you can correct and send me.
I am using the Oracle database.

Att.UsandoBancoDados.zip (28,0,KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.