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 mssqlconnection required
  • query value required
  • params object required
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