how to insert data in sql ???
@guptasweb Refer this link which is having complete details
You will be first installing the Database package
Then use Connect activity to connect to the DB
Insert records using Execute Non Query activity with insert SQL command
Hope that helps.
Please have a look.
Hope this helps,
how to write insert sql command for thousands of data??
You can use “Execute Non Query” Activity which is the faster way of inserting the Data to SQL server.
but how to write?I know insert query…could you pls show me how to write insert query for 1000 rows?
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”.