一些SQL语言喜欢称此类型为NUMERIC类型,其它一些SQL语言则引入了MONEY数据类型,MONEY数据类型被定义为小数点右侧带有两位的小数。
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.
Scale设置小数点右侧的位数。
Scale sets the number of digits to the right of the decimal.
例如,要使用精确到小数点右侧两位的数字显示Totalincome值,选择“Detail1”部分的“TotalIncome”列下面的单元格。
For instance, to display the Total Income values with two Numbers to the right of the decimal, select the cell under the "Total Income" column in the "Detail1" section.
数值数据类型的小数位数是小数点右侧的位数。
The scale of a numeric data type is the number of digits to the right of the decimal point.
可选项。指示小数点右侧显示位数的数值。默认值为- 1(指示使用的是计算机的区域设置)。
NumDigAfterDec Optional. Indicates how many places to the right of the decimal are displayed. Default is -1 (the computer's regional Settings are used).
可选项。指示小数点右侧显示位数的数值。默认值为- 1(指示使用的是计算机的区域设置)。
NumDigAfterDec Optional. Indicates how many places to the right of the decimal are displayed. Default is -1 (the computer's regional Settings are used).
应用推荐