One solution would be to change the query to cast the decimal type to either a smaller datatype or convert to string or binary.
一种解决方案是更改查询,将十进制类型强制转换为较小的数据类型,或者转换为字符串或二进制。
The notably exceptions are the decimal and integer type.
明显的例外是小数和整数类型。
The type attribute is used to indicate how the memory should be rendered, in HEX, Decimal, ASCII, etc.
类型属性用于指示内存应该怎样赋值,以十六进制、十进制、ASCII等等格式。
Some SQL dialects prefer to call this type NUMERIC, and others also include a MONEY data type, which is defined as a decimal number with two places to the right of the decimal.
一些SQL语言喜欢称此类型为NUMERIC类型,其它一些SQL语言则引入了MONEY数据类型,MONEY数据类型被定义为小数点右侧带有两位的小数。
By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.
默认情况下,decimal类型的刻度为0,这意味着DECIMAL数据类型模拟了整数类型。
If you've never encountered an exact precision data type, the distinction between a decimal and floating-point type may be confusing.
如果从未遇到过准确精度数据类型,那么对算术类型和浮点类型可能有些迷惑。
To create a decimal type, you specify the precision and, optionally, the scale for the data to be stored.
要创建算术类型,应当指定保存的数据的精度,并可选地指定数据的刻度。
The storage required for a DECIMAL data type is potentially much larger than it is for a normal floating-point data type.
DECIMAL数据类型需要的存储空间通常要比浮点数据类型大得多。
The price column is created as a DECIMAL data type with a precision of 5 and a scale of 2.
price列创建为DECIMAL数据类型,精度为5,刻度为2。
The BONUS column is data type DECIMAL (9 length , 2 scale).
BONUS列的数据类型为DECIMAL(长度为9,小数点后位数为2)。
The SALARY column is data type DECIMAL (9 length, 2 scale).
salary列的数据类型为DECIMAL(长度为9,小数点后位数为2)。
Usually, coordinate values are stored in numeric columns (float, decimal, or even integer), and the specific type will not affect the code presented here.
通常,坐标值存储在数字列中(浮点、小数,甚至是整数),具体的类型并不影响这里给出的代码。
In some cases, the MTK migrates a source DBMS data type to DECIMAL (x, 0).
在一些情况下,MT k会将一个源dbms数据类型迁移到DECIMAL (x,0)。
If you wanted to represent it as a character entity, you can type a (the decimal value) or a (the hexadecimal value) instead.
如果想将其表示为一个字符实体,可以输入a(十进制值)或A(十六进制值)。
We do this with the line: decimal (7, 2) declare overage decimal (7, 2); where we declared a variable named overage of the type decimal (7, 2).
我们使用下面这行代码来声明变量:decimal (7,2)declareoverage decimal(7,2);这样就定义了一个类型为decimal(7,2)、名为overage的变量。
For instance, the DECIMAL data type can be shortened to DEC or referred to as NUMERIC.
例如,DECIMAL数据类型可以缩短为DEC或表示为NUMERIC。
So unlike an int, this is the type of number that can have Numbers after a decimal place.
所以,不同于int,这个类型的数字,可以有小数位。
The decimal data type is used to specify a numeric value.
小数数据类型用于指定一个数值。
The scale of a numeric data type is the number of digits to the right of the decimal point.
数值数据类型的小数位数是小数点右侧的位数。
This is because TBCDField uses the currency data type that has a fixed scale of 4 decimal places.
BCD字段类型使用了货币类型,这种类型是小数点后是4位数。
NET MVC 4 Models to allow this type of decimal to be stored as is in the database? I believe float is the correct answer.
净mvc4模型允许这种类型的十进制存储为数据库中吗?我相信浮动是正确的答案。
NET MVC 4 Models to allow this type of decimal to be stored as is in the database? I believe float is the correct answer.
净mvc4模型允许这种类型的十进制存储为数据库中吗?我相信浮动是正确的答案。
应用推荐