Hi Blue Prismian,
I would to able to insert multiple rows of collection into a table of database MSSql (not one by one with loop because it's more slow). I create an action for execute query. My query is:
"INSERT INTO Table(Type,Id)
VALUES( (SELECT campo FROM Collezione output)
,'"&[Id]&"');"
"Id" is an int variable.
"Collezione output" is the collection that i would insert into database.
"campo" is a text value of Collection output.
the message error is :Incorrect syntax near output
Can you help me, please?Any solutions alternative will be appreciate :)
Do you have improve code (c# or another) for to do this?
Thanks.
