Frends.MicrosoftSQL.BatchOperation / 2.2.0
Summary
Applies one parameterised statement once per element of a JSON array, so a set of rows is written by a single Task rather than by a loop around a query Task.
Typical use — writing a moderate batch the Process already holds; bulk insert is the better tool for large volumes into one table
Input parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| ConnectionStringSecret | String |
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; |
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; |
Connection string. |
| Query | String |
– | INSERT INTO MyTable (id, first_name) VALUES (@id, @first_name) |
Query string for batch operation. |
| InputJson | String |
– | [{\"Id\":1,\"first_name\":\"Foo\"},{\"Id\":2,\"first_name\":\"Bar\"}] |
JSON array for batch operation. |