Skip to main content

Description

The SQL Node lets you run queries, transactions, or stored procedures on MS SQL Server.

Run Query

Runs a SQL a single query statement.
ParameterTypeDescription
MS SQL ConnectionListSelect MS SQL database connection. To create a new connection, click plus.
SQL QueryCognigyScriptEnter a valid SQL query in the Query field.
ParameterTypeDescription
Where to store the resultList
  • Input — stores the result in the Input object.
  • Context — stores the result in the Context object.
Input Key to store ResultCognigyScriptEnter the key where the result should be stored.
ParameterTypeDescription
Stop on ErrorToggleLets you configure whether to stop Flow execution when an error occurs or not.

Run Transaction

Runs a transaction.
ParameterTypeDescription
MS SQL ConnectionListSelect MS SQL database connection. To create a new connection, click plus.
QueryCognigyScriptEnter a valid SQL transaction query in the Query field. You do not need to add the “BEGIN TRANSACTION” and “COMMIT” fields, since this will be done implicitly. If you want to work with Try / catch blocks and do more advanced transactions with rollbacks, use Run Query instead.
ParameterTypeDescription
Where to store the resultList
  • Input — stores the result in the Input object.
  • Context — stores the result in the Context object.
Input Key to store ResultCognigyScriptEnter the key where the result should be stored.
ParameterTypeDescription
Stop on ErrorToggleLets you configure whether to stop Flow execution when an error occurs or not.

Run Stored Procedure

Runs a stored procedure. The stored procedure must exist in the database specified under Connection.
ParameterTypeDescription
MS SQL ConnectionListSelect MS SQL database connection. To create a new connection, click plus.
Stored Procedure NameCognigyScriptEnter the name of the stored procedure.
InputsJSONEnter an array of input parameters of your stored procedure as defined in the database. You can forward parameters from the Context to the database, for example. Parameters must be specified in an array of objects that define the input parameter in the following format: {name,value,type}
OutputsJSONEnter an array of output parameters of your stored procedure as defined in the database. You can forward parameters from the database to the Context, for example. Parameters must be specified in an array of objects that define the output parameter in the following format: {name,value,type}
ParameterTypeDescription
Where to store the resultList
  • Input — stores the result in the Input object.
  • Context — stores the result in the Context object.
Input Key to store ResultCognigyScriptEnter the key where the result should be stored.
ParameterTypeDescription
Stop on ErrorToggleLets you configure whether to stop Flow execution when an error occurs or not.
I