Execute Query
Execute a query on database.
Last updated
Execute a query on database.
Last updated
Execute a query on a database and store the result in a variable.
Input : The DbHandle object to reference the opened database connection.
Command Type:
Text
- Executes the query specified in the SQL parameter.
Stored Procedure
- Invokes the procedure name specified in the SQL parameter.
Connection String : Optional
The connection string to establish a database connection.
Over Time : The time (in milliseconds) to wait for the activity to run before an error is thrown.The default value is 30 seconds.
Parameters :
Clicking the selector button in the activity opens the Database Parameters Dialog in which Parameter Name, Direction, Type, and Value to be created.
The variable that stores the number of rows of the result table.
Sql String : The Sql string to be executed. Specify the stored procedure name when setting the command type as a stored procedure.'
VariableInQuery : Specify whether the given query string contains variables or not.
Output : The variable that stores the output of the sql query.
Row Count :