Microsoft SQL Server on-premises - Execute a SQL stored procedure

Use the Microsoft SQL Server on-premises - Execute a SQL stored procedure action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to run the SQL statements of a stored procedure.

For more information about the Microsoft SQL Server on-premises connector, go to Microsoft SQL Server on-premises.

Before you begin: 

Jump to:

Configure the Microsoft SQL Server on-premises - Execute a SQL stored procedure action

Note: 

This action has the following limitations:

  • 'EXECUTE' cannot be used within a stored procedure as this is not supported by the Microsoft SQL Server on-premises connector. See EXECUTE (Transact-SQL) for additional information.

  • Uses the sp_describe_first_result_set operation. See sp_describe_first_result_set for additional information.

  • Temporary tables cannot be used within a stored procedure.

  • Table schema cannot be changed within a stored procedure.

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

  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. Select items for the Output.

Microsoft SQL Server on-premises - Execute a SQL stored procedure action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Microsoft SQL Server on-premises connection to use to run the stored procedure.

To refresh the available connections, click .

(n/a)
Stored procedure

The stored procedure of SQL statements that you want to run.

 Text, Decimal, Integer, Boolean, DateTime, Collection
  Item limit

The number of records to return. The maximum number of items that can be returned is 5,000.

 Integer
  Add parameter

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. See Microsoft SQL Server on-premises API for more details. The following values are returned:

  • Is full result set: (Boolean) Returns False if a data type was excluded, like read-only columns.
  • Rows: (Object)
    • Returns just the first result set (up to the Item limit or 5,000 records), regardless of how many the stored procedure returns.
 Object