blocks|key|510954|text|使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|510955|select+1/3.0|code-block|syntax|javascript|510956|这将完成这项工作。|510957|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

use 

<pre><code>select 1/3.0
</code></pre>

This will do the job.

blocks|key|511004|text|因为SQL+Server执行整数除法。试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|511005|select+1+*+1.0+/+3|code-block|syntax|javascript|511006|当您将整数作为参数传递时，这很有帮助。|511007|select+x+*+1.0+/+y|511008|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Because SQL Server performs integer division. Try this:

<pre><code>select 1 * 1.0 / 3
</code></pre>

This is helpful when you pass integers as params.

<pre><code>select x * 1.0 / y
</code></pre>

blocks|key|511086|text|如果你正在寻找一个常量，来自stb和xiowl的建议是很好的。如果您需要使用现有的整型字段或参数，可以先将它们转换为浮点型：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|511087|SELECT+CAST(1+AS+float)+/+CAST(3+AS+float)|code-block|syntax|javascript|511088|或|511089|SELECT+CAST(MyIntField1+AS+float)+/+CAST(MyIntField2+AS+float)|511090|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

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:

<pre><code>SELECT CAST(1 AS float) / CAST(3 AS float)
</code></pre>

or 

<pre><code>SELECT CAST(MyIntField1 AS float) / CAST(MyIntField2 AS float)
</code></pre>

blocks|key|511130|text|看起来这个技巧在SQL+Server中有效，而且更短(基于前面的答案)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|511131|SELECT+1.0*MyInt1/MyInt2|code-block|syntax|javascript|511132|或者：|511133|SELECT+(1.0*MyInt1)/MyInt2|511134|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Looks like this trick works in SQL Server and is shorter (based in previous answers) 

<pre><code>SELECT 1.0*MyInt1/MyInt2
</code></pre>

Or:

<pre><code>SELECT (1.0*MyInt1)/MyInt2
</code></pre>

blocks|key|294665|text|没有必要同时对它们进行强制转换。分区的结果数据类型始终是具有较高data+type+precedence的数据类型。因此，解决方案必须是：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|294666|SELECT+CAST(1+AS+float)+/+3|code-block|syntax|javascript|294667|或|294668|SELECT+1+/+CAST(3+AS+float)|294669|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms190309.aspx^0|W|K|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

It's not necessary to cast both of them. Result datatype for a division is always the one with the higher <a href="https://msdn.microsoft.com/en-us/library/ms190309.aspx" rel="noreferrer">data type precedence</a>. Thus the solution must be:

<pre><code>SELECT CAST(1 AS float) / 3
</code></pre>

or

<pre><code>SELECT 1 / CAST(3 AS float)
</code></pre>

blocks|key|511235|text|使用这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|511236|select+cast((1*1.00)/3+AS+DECIMAL(16,2))+as+Result|offset|length|style|CODE|511237|在这里，在这个sql中，首先转换为浮点型或乘以1.00时，.Which输出将是浮点型number.Here，我认为是两位小数。你可以选择你需要的东西。|511238|entityMap^0|0|0|1E|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

<h2>Use this</h2>

<code>select cast((1*1.00)/3 AS DECIMAL(16,2)) as Result</code>

Here in this sql first convert to float or multiply by 1.00 .Which output will be a float number.Here i consider 2 decimal places. You can choose what you need.

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:

<pre><code>select 1/3
</code></pre>

That currently returns <code>0</code>. I would like it to return <code>0,33</code>.

Something like:

<pre><code>select round(1/3, -2)
</code></pre>

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

How to get a float result by dividing two integer values using T-SQL?

SQL Server

使用T-SQL和Microsoft SQL Server，当我在两个整数之间进行除法时，我想指定小数位数，如下所示：select 1/3它当前返回0。我希望它返回0,33。类似于：select round(1/3, -2)但这并不管用。如何才能达到预期的效果？

问如何使用T-SQL将两个整数值相除，得到一个浮点数结果？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用T-SQL将两个整数值相除，得到一个浮点数结果？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用T-SQL将两个整数值相除，得到一个浮点数结果？
EN