How to use Bulk Insert/Bulk Update in Database Automation

Hi @shubham_dubey

Bulk insert you will want to use it instead of Insert when you have large amount of data. Should be faster.

Concerning Bulk Update, it is very useful when you need to update values in your database. You just need to be very careful with datatypes. you might get errors with it that you won’t have with Insert/Bulk Insert.
In order to avoid that, you could first do a query in order to clone the datatable and fill it with the data you want to update.
Just provide the column names that make your primary key

best regards