Question

参数不足 期待是2 是怎么回事

C# String constr = "DSN=selldsn"; odbcconn = new OdbcConnection(constr); odbcconn.Open(); String selectstr = " select 月份 , sum(基本) ,sum(进*数) ,sum(售*数) as 和,进乘数, 售乘数 into 表1 from 统计 group by 月份 ";
OdbcCommand cmd = new OdbcCommand(selectstr, odbcconn); OdbcDataReader r = cmd.ExecuteReader(); r.Read();

odbcconn.Close();

Answer 1

"select 月份 , sum(基本) as 和,sum(进*数) as 和乘数,sum(售*数) as 售乘数 from 统计 group by 月份";
你写的那是什么玩意，全错了了两个关键字都报错，期待为2就是根本语法都错了，INTO关键字，AS关键字，"，"号都在报错