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.

For more information about the Azure SQL connector, go to Azure SQL.

Before you begin: 

Jump to:

Configure the Azure SQL - Execute a SQL stored procedure

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add, rename, and copy actions.

  2. Select a Connection. If you do not have a connection, see Add a connection.
  1. Select the Stored procedure.
  2. Specify the Item limit.
  3. If the stored procedure has input parameters, they will be added automatically.
  4. Create or select a variable for the output.

Note: 'EXECUTE' cannot be used within a stored procedure as this is not supported by the Azure SQL connector. See EXECUTE (Transact-SQL) for additional information.

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 The parameters required for the stored procedure. The parameters are added automatically. 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