如何通过使用T-SQL将两个整数值相除来获得浮点结果？ [英] How to get a float result by dividing two integer values using T-SQL?

问题描述

使用T-SQL和Microsoft SQL Server，我想在两个整数之间进行除法时指定小数位数：

Using T-SQL and Microsoft SQL Server I would like to specify the number of decimal digits when I do a division between 2 integer numbers like:

select 1/3

当前返回 0 。我希望它返回 0,33 。

That currently returns 0. I would like it to return 0,33.

类似的东西：

select round(1/3, -2)

但这不起作用。如何获得理想的结果？

But that doesn't work. How can I achieve the desired result?

推荐答案

如果您要寻找一个常数，stb和xiowl的建议就很好。如果需要使用现有的整数字段或参数，则可以将它们首先转换为浮点数：

The suggestions from stb and xiowl are fine if you're looking for a constant. If you need to use existing fields or parameters which are integers, you can cast them to be floats first:

SELECT CAST(1 AS float) / CAST(3 AS float)

或

SELECT CAST(MyIntField1 AS float) / CAST(MyIntField2 AS float)

这篇关于如何通过使用T-SQL将两个整数值相除来获得浮点结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！