Rowcount for multiple insert statements
862273May 16 2011 — edited May 16 2011Hi I am new to sql, so bare with me here.
I was wondering how to use (if possible) rowcount with multiple insert statements like below.
insert into table1 values ('a', '1');
insert into table1 values ('b', '2');
I read that %rowcount will only give you the result of the most recently executed sql statemen. I can not use a single insert statement because the data being inserted is different for each insert statement