Write multiple rows in database from process

Hello,

Is there a way to insert/update multiple rows ( from an array process variable) using "Query Database" or "Stored Procedure" nodes, but without generating one instance for each row to be inserted/updated?

Thank you.

  Discussion posts and replies are publicly visible

Parents
  • Hi,

    Query Database is depricated.
    Write to Database is the right approach.

    and yes you can achive write to database using "Query Database" , but you need more manupulation

    Insert INTO table1 (Name,InvoiceNo)
    Select 'Abc',2323444
    UNION
    Select 'CCC',1212122
    UNION
    Select 'DDD',445455

    You can generate the Select statement dynamically using apply for foreach in the expression
Reply
  • Hi,

    Query Database is depricated.
    Write to Database is the right approach.

    and yes you can achive write to database using "Query Database" , but you need more manupulation

    Insert INTO table1 (Name,InvoiceNo)
    Select 'Abc',2323444
    UNION
    Select 'CCC',1212122
    UNION
    Select 'DDD',445455

    You can generate the Select statement dynamically using apply for foreach in the expression
Children