Batch Insert

DavidE · Apr 28, 2012

Hi all, Can someone please post or direct me to an example of how to do a batch insert into a DB. I'm grabbing the values from a multiple select box and what to insert the values into a DB all at once. Thanks, D.you juse loop through each value and build a SQL string and insert whatever = split(request("SomeCrap"), ", ") then loop through this array for sSQL = " Insert into (columns....) TableName value (......)" loop execute(sSQl) Hi, I know you can loop through each item and insert into the DB, but there has to be a more efficient way -- only 1 call being made to the DB. If there are 20 items, that's 20 calls. Thanks, D.i did not say loop through each item and insert i said loop through each item and BUILD A SQL STRING...look at my post again...see the for.....loop AFTER the loop you execute the string ONE trip.....MULTIPLE inserts you can pass that entire string to an SP and then parse it in the SP and insert Akhilesh... How do you do an sql insert statement to insert multiple rows? I thought insert was only for one row... would you seperate multiple insert statements by ; ? Sorry Ive wondered the same thing myself before.I was wondering the same thing too. The only way I know of doing it is: INSERT INTO Table (Columns) SELECT Columns FROM Table WHERE etc. But in this case, we're not grabbing the data from a table.

Batch Insert

DavidE

New Member