为什么 SQL Server 会将两个整数相除的结果四舍五入?
我有一个表,其中有一个 smallint 列,其中包含整数形式的百分比(即 50、75、85 等)
I have a table with a smallint column that contains percentages as whole numbers (i.e., 50, 75, 85, etc.)
当我将此列除以 100 时,如
When I divide this column by 100, as in
SELECT MY_COLUMN/100 AS PCT_AS_FRACTION
FROM MY_TABLE
结果四舍五入到最接近的整数.例如,对于包含数字50"的行,我的结果为零.
the result is rounded to the nearest whole number. For example, for a row that contains the number "50", I get zero as my result.
我可以用一个简单的语句来复制这个:
I can duplicate this with a simple statement:
SELECT 50 / 100 AS TEST_VALUE
这是为什么,我怎样才能获得更精确的结果?
Why is that, and how can I get more precision in my result?
推荐答案
当你做整数除法(整数除以整数)时,你总是得到一个整数答案.50/100 = .50,用整数来说是 0.
When you do integer division (integer divided by integer) you always get an integer answer. 50/100 = .50, which is 0 in integer-speak.
你试过用 MY_COLUMN 除以 100.0 吗?
Have you tried dividing MY_COLUMN by 100.0?
相关文章