Execute command

Executes a SQL command in a SQL Server database, and returns the number of rows affected by the query.

Note

This action does not return the result of the executed query. It simply returns the number of rows affected by the query.

Properties

Name	Data type	Description
Title	Optional	The title or name of the command.
Connection	Required	The SQL Server connection.
SQL expression and parameters	Required	The command to execute along with any parameters.
Result variable name	Optional	The name of the variable that will contain the number of rows affected.
Command timeout (sec)	Optional	The time limit for command execution before it times out. Default is 120 seconds.
Description	Optional	Additional notes or comments about the action or configuration.

Example: How to use parameters

To use parameters in the query, declare and assign variables in the SQL parameters property.
Then use the parameters in the query.


UPDATE Users SET [Name] = @Name WHERE UserId = @UserId

Example: How to use Flow variables in the command expression

To use Flow variables in a SQL query as part of the expression, you need to first declare a variable as Global and assign a value to the variable.
Then, enclose the variable in curly brackets like with the TableName variable shown in the example below.

-- We have declared a Flow variable named TableName and assigned a value to it in a previous action.
UPDATE {TableName} SET [Name] = @Name WHERE UserId = @UserId

Returns