更新时间:2022-12-09 17:33:32
如果您要寻找一个常数,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)