sql - 数学表达式返回零

Question

抱歉问了一个愚蠢的问题，但这个问题让我难住了。

SELECT 
81234 / 160000 * 100                    AS Try1,
CAST((81234 / 160000 * 100) AS float)   AS Try2

答案是 50.77125，但两个值都返回零。有什么问题？

谢谢，

Answer 1

尝试使用小数点。

就像是

SELECT 
81234 / 160000 * 100                    AS Try1,
CAST((81234 / 160000 * 100) AS float)   AS Try2,
81234. / 160000. * 100.                    AS Try3

SQL Fiddle DEMO

来自 / (Divide) (Transact-SQL)

If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional part of the result truncated.