数据库插入语句遇到如下问题 恳请高手解答！

当向数据库表中插入一个501列的数据时 遇到错误如下：

未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 System.Data.dll 中。
其他信息: 不能创建大小为 8062 的行，该大小大于所允许的最大值 8060。
语句已终止。

插入语句如下：

insert into KNNSEPERAT values ('0','0','8.96712374273558','0','0','0','0','0','0','0','0','0','0','3.25848107946056','0','2.83380140640777','0','0','0','0','0','13.4705623925333','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','6.08999702971382','3.36764059813331','0','0','0','0.00995033085316809','0','0','0','0','0','3.09149689553837','0','0','0','5.99246429719128','0','0','0','0','0','0','0','0','0','0','0','0','0','7.22237629279613','0','0','0','0','2.09440416621295','0','0','0','2.20388015752157','0','0.698134722070984','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','12.9126006576281','0','0','0','0','0','0','0','11.9675076438144','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','11.9675076438144','4.07770692106908','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','8.15541384213815','0','0','0','0','0','0','0','0','0','24.4662415264145','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3.04499851485691','0','0','0','0','0','0','4.07770692106908','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3.73790768518129','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','16.7592249828027','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','8.37961249140136','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1.39626944414197','0','0','0','1.9473377010465','0','0','0','3.9891692146048','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','体育')

请问这是什么错误，如何解决？？谢谢！

9 个解决方案

#1

一行数据超过8060,超过上限,不允许.

#2

每行每行字节数最多(8,060) 

#3

字段用varchar(max),text...

#4

如果是2005以上版本 用varchar(max)

#5

看看表里的字段定义，看看所有字段的大小总和是不是超过了8060。
比如，可能有个字段，定义了nchar（4000）

#6

实在不行可以分开两个表，或者细化你现在的表的内容到其他几个表中，

#7

要不就先

Insert ....

再

Update ....

#8

可是前面500列的数据类型为float型的啊？能用varchar(MAX)吗？？

#9

推荐用text