insert record loop

+ Reply to Thread

+ Ask a Question

Ask a Question related to Dreamweaver AppDev, Design and Development.

What's faster - loop for insert or insert...select.

What is faster if I'm moving large numbers of records (anywhere from 10,000 to 300,000 records per archive) from one query to another table? 1)...
Insert Loop values into DB Problem

:confused; How do I call the loop when inserting the values into my DB? I am getting an error message. Here is the Insert Statement: ...
Can you put an Insert Command object in a loop?

Hi I am trying to figure out how to insert a variable number of records into one table in Access, therefore without stored procedures, in ASP...
insert a record

Hi every one, I have a problem inserting a record... error 500.100 (Operation must use an updateable query) or Unknown variable or something... ...
How to select and then loop while insert

I need help in writing a stored procedure on SQL Server 2000. Basically the stored procedure's primary task is to generate invoice records and...