为什么 SQL Server 会将两个整数相除的结果四舍五入? [英] Why does SQL Server round off results of dividing two integers?

问题描述

我有一个表，其中有一个 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?

这篇关于为什么 SQL Server 会将两个整数相除的结果四舍五入?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！