By default, the scale for a DECIMAL type is 0, which means the DECIMAL data type mimics an integer type.
默认情况下,decimal类型的刻度为0,这意味着DECIMAL数据类型模拟了整数类型。
To create a decimal type, you specify the precision and, optionally, the scale for the data to be stored.
要创建算术类型,应当指定保存的数据的精度,并可选地指定数据的刻度。
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.
您也可以使用固定精度的十进制类型,或者在使用浮点数之前将它们强制转换为固定精度的十进制类型。
The type attribute is used to indicate how the memory should be rendered, in HEX, Decimal, ASCII, etc.
类型属性用于指示内存应该怎样赋值,以十六进制、十进制、ASCII等等格式。
Usually, coordinate values are stored in numeric columns (float, decimal, or even integer), and the specific type will not affect the code presented here.
通常,坐标值存储在数字列中(浮点、小数,甚至是整数),具体的类型并不影响这里给出的代码。
The notably exceptions are the decimal and integer type.
明显的例外是小数和整数类型。
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数据类型被定义为小数点右侧带有两位的小数。
If you've never encountered an exact precision data type, the distinction between a decimal and floating-point type may be confusing.
如果从未遇到过准确精度数据类型,那么对算术类型和浮点类型可能有些迷惑。
SQL-92 includes a decimal data type, which is an exact numeric type for representing fixed point decimal Numbers and performs basic arithmetic operation on decimal Numbers.
SQL- 92包括DECIMAL数据类型,它是用于表示定点小数的精确数字类型,它可以对小数进行基本的算术运算。
The storage required for a DECIMAL data type is potentially much larger than it is for a normal floating-point data type.
DECIMAL数据类型需要的存储空间通常要比浮点数据类型大得多。
In some cases, the MTK migrates a source DBMS data type to DECIMAL (x, 0).
在一些情况下,MT k会将一个源dbms数据类型迁移到DECIMAL (x,0)。
For instance, the DECIMAL data type can be shortened to DEC or referred to as NUMERIC.
例如,DECIMAL数据类型可以缩短为DEC或表示为NUMERIC。
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)。
Both default decimal character and default decimal character type properties must be set.
必须设置默认十进制字符和默认十进制字符类型属性。
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的变量。
So unlike an int, this is the type of number that can have Numbers after a decimal place.
所以,不同于int,这个类型的数字,可以有小数位。
If you have no decimal data type available, an alternative is to work with integers, e. g. do money calculations entirely in cents.
如果你没有合适的小数数据类型可用,一个替代的方案是使用整数。比如,在计算钱数时把单位转化为分。
The decimal data type is used to specify a numeric value.
小数数据类型用于指定一个数值。
Thee decimal data type is used to specify a numeric value.
小数数据类型用于指定一个数值。 。
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模型允许这种类型的十进制存储为数据库中吗?我相信浮动是正确的答案。
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位数。
You should also use a Currency data type if you plan to perform many calculations on a field that contains Numbers with one to four decimal places.
若要对包含一到四位小数的数字的字段执行很多计算,也应该使用“货币”数据类型。
And most decimal fractions cannot be represented by a binary type.
和大多数十进制小数不能用二进制表示的类型。
A floating literal consists of an integer part, a decimal point, a fraction part, ane or e, an optionally signed integer exponent, and an optional type suffix.
浮点文字量由整数部分,小数点,小数部分,e或e,可选的有符号整数指数,以及可选的类型后缀组成。
A floating literal consists of an integer part, a decimal point, a fraction part, ane or e, an optionally signed integer exponent, and an optional type suffix.
浮点文字量由整数部分,小数点,小数部分,e或e,可选的有符号整数指数,以及可选的类型后缀组成。
应用推荐