SQL Configuration with Simple Query

Owned by Pooja Yadav (Deactivated), created
Last updated: Mar 10, 2022 by shreedutta.mukherjee (Deactivated)
2 min read

Introduction

In this section of our documentation, the steps to configuring simple queries will be described.

Steps to configure

  1. Drag and drop the SQL task in the automation and click on it. The form below will appear on the screen.

  2. Add name and an appropriate description for reference.

  3. Select the connection that has been created for the SQL or create a new one from the plus button. Click here to know how to create an SQL connection.

  4. Choose the type of query according to the action you are going to perform. You can choose from the following query types:

    • Select: A Select statement retrieves zero or more rows from one or more database tables or database views.

    • Insert: The SQL Insert statement is used to add new rows of data to a table in the database.

    • Update: The use of update SQL queries in access databases is to add, change, or delete the information in an existing record.

    • Delete: The SQL Delete query is used to delete the existing records from a table. You can use the WHERE clause with a DELETE query to delete the selected rows, otherwise, all the records would be deleted.

  5. Add the desired query as per the requirement and click on the tick button to verify the query. A query is a request for data or information from a database table or combination of tables.

  6. Once the written query is valid then click on save to configure it. In case of an error, correct the query and verify it again.

The structure will remain the same for other simple queries, you just need to modify the query as per the requirement.