批量插入数据问题
sqlStr = @"insert into R.R1_HXCYL_SYS_HISTORY(NAME,FIELD_ID,TS,PERIOD,REQUEST,STEPPED,VALUE,STATUS,SECONDS)
values ('ATCDAI','605618176','14-MAR-18 17:13:13.0','600',1,0,3.348135,0,'1521018793');
insert into R.R1_HXCYL_SYS_HISTORY(NAME,FIELD_ID,TS,PERIOD,REQUEST,STEPPED,VALUE,STATUS,SECONDS)
values ('ATCDAI','605618176','14-MAR-18 17:14:13.0','600',1,0,3.746651,0,'1521018853');";
OdbcCommand cmd = new OdbcCommand(sqlStr, Conn);
int result = cmd.ExecuteNonQuery();
Conn.Close();
请教个问题,sql 是多个insert into 语句,一次插入多行,插入报错;
提示语法错误;
ERROR [42000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "insert": line 3 col 15 (at pos 215)
我是用odbc连的hana数据库,有人帮忙解答一下吗?
求大神帮忙,在线等...