Azure SQL -Execute a SQL stored procedure

Use the Azure SQL - Execute a SQL stored procedure action A tool for building the processes, logic, and direction within workflows. to execute a SQL stored procedure.

Before you start 

Configure the Azure SQL - Execute a SQL stored procedure

The steps required to configure the action are given below. The Azure SQL - Execute a SQL stored procedure action fields and settings table describes all the required and optional configuration fields.

  1. Select a Connection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store..
  2. Select the Stored procedure.
  3. Specify the Item limit.
  4. If the stored procedure has input parameters, click Add field in Parameters to specify their values.
  5. Create or select a variable for the output.

Azure SQL - Execute a SQL stored procedure action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Azure SQL connection is used to create, update, and delete records.

To refresh the available connections, click .

(n/a)

Stored Procedure The stored procedure list is populated based on the connection selected. Select the stored procedure to execute. Text, Decimal, Integer, Boolean, DateTime, Collection
Item Limit Item limit contains the maximum amount of rows that will be returned from the stored procedure result. The default is 1000 items and the maximum is 5000 items. Input the item limit. Integer
Parameters Click Add parameter to define the values of any required input parameters of the stored procedure. Text, Decimal, Integer, Boolean, DateTime, Collection
Output Items Stores the result of the action as an object. The following values are returned:
  • is full result set: (Boolean) Returns true if the table only contains supported column types. If any unsupported column types exist, e.g. varbinary, then it will return false.
  • Rows: (Object) Returns just the first result set, regardless of how many the stored procedure returns.
Object