Split on SQL Server

Question

In SQL Server 2005 Express, the result is lower

SELECT 100/15 - Result 6

But I want to get an approximate value of 7 (for example, using a calculator)

100/15 = 6.6666 ..

How to do it on SQL Server?

Answer 1

You should use decimal numbers, for example. 100 / 15.0. If you use integers, the result is interpreted as an integer and truncated to the largest integer that is less than or equal to the result.

Answer 2

SELECT cast (100 as float) / (15 as float)

Answer 3

You want SQL Server to perform floating point division rather than integer division. If you use literal values, as in your example, the denominator suffix is ​​with .0 to force SQL Server to treat it as a floating point value.

 SELECT 100 / 15.0 

Otherwise, make sure you specify your variables as FLOAT .

Answer 4

Try declaring the variables as float:

 DECLARE @var1 FLOAT DECLARE @var2 FLOAT SET @var1 = 100 SET @var2 = 15 SELECT @var1 / @var2