"Ron Vecchi" <vencenzo@comcast.net> wrote in message
news:ObKEFlwVDHA.2032@TK2MSFTNGP11.phx.gbl...
> Is there a way to implement a batch INSERT.
>
> Currently in my asp.net code I perform a loop. As each loop runs
through I
> construct my Insert command and execute it through ado.net.
>
> I was just wondering if you can construct some sort of a batch INSERT
> command. Mabey pass an array or hash of information as a parameter to
a
> stored proc. Then in SQL (if possible) loop through and perform
querys.
>
> Any Ideas?
>
>
> Thanks,
>
> Ron Vecchi
>
>

"Rajesh Peddireddy" <peddireddyrajesh@rediffmail.com> wrote in message
news:059101c3570d$6a810ea0$a501280a@phx.gbl...

>-----Original Message-----
>Is there a way to implement a batch INSERT.
>
>Currently in my asp.net code I perform a loop. As each
loop runs through I
>construct my Insert command and execute it through
ado.net.
>
>I was just wondering if you can construct some sort of a
batch INSERT
>command. Mabey pass an array or hash of information as a
parameter to a
>stored proc. Then in SQL (if possible) loop through and
perform querys.
>
>Any Ideas?
>
>
>Thanks,
>
>Ron Vecchi
>
>
>.
>