execute

This block is part of the mssql group and was last modified in core v10.4.28.

execute v10.4.28

Executes provided query on the MSSQL server.

In pins 3
  • connection required
    mssqlconnection
  • query required
    value
  • params required
    object
Out pins 4
  • connection
    mssqlconnection
  • results
    array
  • affected
    number
  • error
    value

A typical wiring for execute: value feeds the query pin; the connection out pin feeds close connection.

Studio canvas example for the execute block: typical wiring for execute.

Version history

Introduced in v10.4.28.


Back to mssql Return to the main group to view all sub-groups Back to query Return to the group to view all blocks within this group