Database Automation- Execute Query

ExecuteQuery

When to use ExecuteQuery

This activity helps you call and execute the given SQL query in the database.

Figure 1

Activity Name

Picture

ExecuteQuery

a

Technical Reference

Figure 1.2

p 

S.no

Description

1

Specify the existing DB connection which is stored as a SQLConnection variable during ConnectDB

2

Specify the parameters if you are going to pass arguments in the query

3

Specify the SQL query which you need to execute

4

Select the type either Text or StoreProcedure

5

Displays the action that the activity performs in the workflow

6

Specify whether to continue executing the workflow even if the activity fails

7

Specify the datatable variable which holds the data  that returns after executing the query.

 r    DBConnection should be defined as a SqlConnection System.Data.SqlClient.SqlConnection  
               
 Type has list of choices to select from the dropdown.

a Activity: The ExecuteQuery helps executing a query (type or stored procedure) that interacts with the database to extract/retrieve the required data.

 

Release date
Version
v4.0.2