保存到SQL Server数据库时报错： 8115:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Arithmetic overflow error converting nvarchar to data type numeric.
经过细查，发现是有个字段小数点后面太多了：
array( [lrv] => 38.9 [ima126] => 34 [mblrl] => 28.69203333333333333333333333333333333333 [lrdcl] => 136 [mxqzdf] => 12.512 [mxkpidf] => 136 [kpiscore] => 108.671 [kpidf] => 100 )
保存前保留几位小数即可
保存到SQL Server数据库时报错： 8115:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Arithmetic overflow error converting nvarchar to data type numeric. 经过细查，发现是有个字段小数点后面太多了：array( [lrv] => 38.9 [ima126] => 34 [mblrl] => 28.6920333333333333333333333333333333
Review
Statisticians, applied mathematicians, engineers, and computer scientists will find this well-written book useful.
-Journal of Statistical Computation and Simulation
the authors of this well balanced textbook succeed admirably well in teaching the subject to the union of students in math and in cs, and to engineers. The danger with subjects that cut accross fields is that they might appeal to the intersection of audiences involved rather than to the much larger union. The authors seem to be at home with all the
type
s of readers, they realize that the lingo and the aim is different for the different and diverse groups of students. Indeed, the tools of information theory,
data
compression, and
arithmetic
coding are widely used in science. While the mathematical parts of the subject is old[Shannon, Kolmogorov..., measurements of information, entropy, channel capacity], the applications are still going strong, with new things coming out at a fast rate right up to the present. So the emphasis in the book on
data
and image compression is very appropriate. There is even a JPEGtool user's guide in the appendix.
错误信息：
Arithmetic
overflow
error
converting
expression to
data
type
int.（将expression转化为数据类型int时发生算术溢出错误）
原因：itemcount 为int类型，在sum...
java.lang.RuntimeException: com.microsoft.
sql
server
.jdbc.
SQL
Server
Exception:
Arithmetic
overflow
error
converting
numeric
to
data
type
numeric
.
......
这个报错很直接，一眼就看出来什么问题。由于产品的复杂性，当客户向我们报这个问题时，我们一
上次提到，在客户环境发现这个问题
java.lang.RuntimeException: com.microsoft.
sql
server
.jdbc.
SQL
Server
Exception:
Arithmetic
overflow
error
converting
numeric
to
data
type
numeric
.
......
利用
SQL
Server
Profiler 的 t
CX_SY_
ARITHMETIC
_
OVERFLOW
是SAP ABAP中的一个运行时异常。它表示在执行数学运算时，结果超出了数据类型可以表示的范围。例如，在一个 INT 类型的变量里存储一个超过 2147483647 的数值就会导致 CX_SY_
ARITHMETIC
_
OVERFLOW
异常。
以下是一个 CX_SY_
ARITHMETIC
_
OVERFLOW
异常的示例：
```abap
DATA
lv_num1
TYPE
i VALUE 2147483647.
DATA
lv_num2
TYPE
i VALUE 1.
DATA
lv_result
TYPE
i.
lv_result = lv_num1 + lv_num2. " 这里会抛出 CX_SY_
ARITHMETIC
_
OVERFLOW
异常
在上面的代码中，lv_num1 存储了一个 INT 类型的最大值，lv_num2 存储了 1。当它们相加时，结果超出了 INT 类型的最大值范围，导致了 CX_SY_
ARITHMETIC
_
OVERFLOW
异常的抛出。
要避免 CX_SY_
ARITHMETIC
_
OVERFLOW
异常，可以采取以下措施之一：
- 使用更大的数据类型，如 BIGINT。
- 在进行数学运算之前，先检查结果是否超出了数据类型的范围，如果超出，则不执行该运算。
- 如果你确定将发生 CX_SY_
ARITHMETIC
_
OVERFLOW
异常，可以使用 TRY-CATCH 块来捕获并处理该异常。
