Subject Re: [firebird-support] Insert multiple rows with one Execute ?
Author Helen Borrie
At 06:11 PM 24/08/2005 +0000, you wrote:
>Is there a way you can insert multiple rows with a single execute
>call ? I know you can use the same prepared statement, set different
>bind values and execute everytime but this is going to take N
>roundtrips to the server to insert N rows. Is there a better way ?

It depends on where the data is coming from. You can do

insert into atable (<input list>)
select <exactly-mapped-list>
from <tables>

If you are wanting to insert data from an external source, a server-based
text file with fixed length records, you can set the file up as an external
table and use this syntax to load the data into your real table.