A user reported:
I am coding C# application using ADO.net driver.
string sQuery = "insert into table_name(c1,c2) values ('aaa', 'bbb');"
+ "insert into table_name(c1,c2) values('ccc','ddd');";
dbComm.CommandText = sQuery;
dbComm.CommandType = CommandType.Text;
Then only the 1st INSERT statement works correctly so that data by 1st INSERT is populated into a DB.
Do I have to use multi INSERT statement as
values ('aaa','bbb'), ('ccc','ddd');
Is it a bug? Is there any way to execute more than 2 queries with "+" ?