为什么 SQL Server 会将两个整数相除的结果四舍五入?

2021-12-13 00:00:00 rounding templates 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?

相关文章