One solution would be to change the query to cast the decimal type to either a smaller datatype or convert to string or binary.
一种解决方案是更改查询,将十进制类型强制转换为较小的数据类型,或者转换为字符串或二进制。
You can also use a fixed-precision decimal type, or cast floating-point Numbers to a fixed-precision decimal type before you work with them.
您也可以使用固定精度的十进制类型,或者在使用浮点数之前将它们强制转换为固定精度的十进制类型。
By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.
默认情况下,decimal类型的刻度为0,这意味着DECIMAL数据类型模拟了整数类型。
By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.
默认情况下,decimal类型的刻度为0,这意味着DECIMAL数据类型模拟了整数类型。
应用推荐