Article View: borland.public.cppbuilder.database.multi-tier
Article #1341Re: Multiple INSERT in one Query
From: Jeff Overcash (TeamB)
Date: Sun, 21 Nov 1999 00:00
Date: Sun, 21 Nov 1999 00:00
25 lines
1483 bytes
1483 bytes
No, it can insert multiple rows, but only with a select statement embedded like
Insert into MyTable (c1, c2, c3) Values Select col1, col2, col3 from
MySourceTable
That will do multiple inserts. So the help is correct that the Insert SQL
statement can insert multiple rows, but only in a specific syntax.
"Clayton M. Arends" wrote:
>
> Thanks Jeff,
>
> That's all I needed to know. Why does the help mention "Adds one or more
> new rows of data in a table"? Was the help writer overzealous?
>
> Thanks again. 'till next time,
>
> - Clayton
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Technical Details
Message-ID:
<3838AF83.FFC439F7@onramp.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<819jse$f4e23@forums.borland.com> <38389702.615D9958@onramp.net> <81a5a6$jn24@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,274144d6b95a47ea X-Google-Attributes: gidfcd2b,public From: "Jeff Overcash (TeamB)" <overcash@onramp.net> Subject: Re: Multiple INSERT in one Query Date: 1999/11/21 Message-ID: <3838AF83.FFC439F7@onramp.net> X-Deja-AN: 551472496 Content-Transfer-Encoding: 7bit References: <819jse$f4e23@forums.borland.com> <38389702.615D9958@onramp.net> <81a5a6$jn24@forums.borland.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: TeamB Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier