Re: Bulk insert to sql database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Rujuta Gandhi wrote: 
Hi Arnie

I know that option, but this is used for insertion from the file.
I want to insert the number of rows at a time from the arrays in my vc++
program. I mean as if i have the collection of rows to be inserted at a
time.
Thanks
Ruju

"Arnie" <none> wrote in message
news:uJlF0NoRFHA.3560@xxxxxxxxxxxxxxxxxxxxxxx

"Rujuta Gandhi" <rujuta_g2000@xxxxxxxxx> wrote in message
news:OajZlJlRFHA.3928@xxxxxxxxxxxxxxxxxxxxxxx

Hi

I want to perform the bulk insertion to the SQL database, I
access through
ODBC connection. I want the guidance regarding the same.

Rujuta 

If you mean SQL Server, it has a bulk insert API.  Check the
documentation.

- Arnie





Maybe you can build a long sql
insert into table1 values(...);insert into table1 values(...);...
.

Relevant Pages

  • Re: Hint in map insert
    ... The MS documentation says map::insert can occur in amortized constant time ... I am not sure about it because the insertion point is actually 1 before ... More recent versions of the library benefit from the hint if the ...
    (microsoft.public.vc.stl)
  • Re: Single Liked List Problem at Java
    ... for insertion or deletion. ... documentation, there are lots of ideas there for what you need in an ...
    (comp.programming)