没有足够的系统内存来运行此查询

Question

没有足够的系统内存来运行此查询。可是表数据才287行，就是字段多了一些，怎么办？？内存asp.net

Answer 1

不会啊，这是测试用的。但是我 sql.Append("select avg(t1),sum(t2),avg(t3),sum(t4),avg(t5),sum(t6),avg(t7),sum(t8)," +
                  "avg(t9),sum(t10),avg(t11),sum(t12),avg(t13),sum(t14),avg(t15),sum(t16)," +
                  "avg(t17),sum(t18),avg(t19),sum(t20),avg(t21),sum(t22),avg(t23),sum(t24)," +
                  "avg(t25),sum(t26),avg(t27),sum(t28),avg(t29),sum(t30),avg(t31),sum(t32)," +
                  "avg(t33),sum(t34),avg(t35),sum(t36),avg(t37),sum(t38),avg(t39),sum(t40)," +
                  "avg(t41),sum(t42),avg(t43),sum(t44),avg(t45),sum(t46),avg(t47),sum(t48)," +
                  "avg(t49),sum(t50),avg(t51),sum(t52),avg(t53),sum(t54),avg(t55),sum(t56),avg(t57),sum(t58)," +
                  "avg(t59),sum(t60),avg(t61),sum(t62),avg(t63),sum(t64),avg(t65),sum(t66),avg(t67),sum(t68)," +
                  "avg(t69),sum(t70),avg(t71),sum(t72) from cbdl ");因为要算平均值和求和所以这么写了，难道SQL执行不过来？

Answer 2

用程序计算吧求和平均数，不要用sql