Insert múltiple (o masivo)

[santiago14]

Bueno, investigando un poco encontré esto, igualmente no funciona en Firebird 1.5.
Quisiera que me den una mano.


How to insert multiple rows in a single statement?

There are various approaches. For example, if you wish to insert these:

10 ten
11 eleven
12 twelwe

you can use UNIONs:

Código SQL [-]
INSERT INTO table1 (col1, col2)
SELECT 10, 'ten ' FROM RDB$DATABASE UNION ALL
SELECT 11, 'eleven' FROM RDB$DATABASE UNION ALL
SELECT 12, 'twelwe' FROM RDB$DATABASE;

Please note that datatypes must match (esp. if you use Firebird 1.x).

Lo encontré aqui.

Gracias.