Insert Multiple records

[jmeckley]

How would I pass an array of values into a table? The array comes from a ASP page.

I know how to select multiple Items from one table and insert them into another, but I don't know how to do this with straight values. Is this a programming thing, or can TSQL do this?

The only thing I can think of is to create a temp table, individually insert each item of the array into the temp table and then create a batch insert statement to insert the rows from the temp table to the actaul table. But this seems like excess work.

Any ideas, or can it only be done individually?

Jason Meckley
Database Analyst
WITF

 

[olichap]

Have you tried just looping through the array, executing the INSERT for each element?

From instance

For iInt = 0 to ubound(arArray) - 1
'execute INSERT statement using arArray(iInt) value
next

 

[jmeckley]

that is currently what I have now, I was curious as to whether the list could be inserted with 1 statement as opposed to a loop of individual statments.

Thank you

Jason Meckley
Database Analyst
WITF