Sql data

RPA Discussions
1

how to insert data in sql ???

1 Like
2

@guptasweb Refer this link which is having complete details

3

Hey @guptasweb

  1. You will be first installing the Database package

  2. Then use Connect activity to connect to the DB

  3. Insert records using Execute Non Query activity with insert SQL command

Hope that helps.

Thanks
#nK

4

Hi @guptasweb

Please have a look.

Hope this helps,

Thanks.

5

how to write insert sql command for thousands of data??

6

You can use “Execute Non Query” Activity which is the faster way of inserting the Data to SQL server.

Thanks.

7

but how to write?I know insert query…could you pls show me how to write insert query for 1000 rows?

8

Hi @guptasweb ,

Please help to confirm that do you have an Data table to be inserted onto the SQL Database ?

If so you can Use “Insert” Activity in Database Activity , that will insert the Data in Bulk.

If not Also you can try this in Execute Non Query

INSERT INTO TableName(Column1,Column2,Column3,Column4) VALUES (“A”,“B”,“C”,“D”)

You can also have variables in place of values such as “A”.

Thanks