Skip to content

MS SQL

Description

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

Operation


Choose an Operation from the dropdown:

Connection


Select or create a new database connection, see Connections.

Context Store


The SQL Node executes the configured operation on the database. The query response from the database will be stored in the Context. Specify the store location here.

Run Query

Runs a single SQL query statement. Enter a valid SQL query in the Query field.

Run Transaction

Runs a transaction. Enter 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, then you might want to use the Run Query instead.

Run Stored Procedure

Runs a stored procedure. The stored procedure must exist in the database specified under Connection.

Stored Procedure Name


The name of the stored procedure

Inputs


Enter 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}

Outputs


Enter 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}