Re: Maximun number of unions in a single query

can you just wrap

insert into mytable(col1, col2, col3, col4) values(p1, p2, p3, p4);
insert into mytable(col1, col2, col3, col4) values(p5, p6, p7, p8); etc.

in a stored procedure?

Or, if you really need an insert statement, can you insert into a view and call the stored procedure from an instead of trigger? Received on Thu Jun 09 2005 - 12:02:20 CDT