division in SQL results in 0

Question

division in SQL results in 0	Posted on:  01/09/2006 09:20:13
declare @x int, @y int, @f float set @x = 100 set @y = 2000 set @f = @x / @y print @x print @y print @f in the above code @f prints as 0 instead of 0.05 how would i correct that?

Answer 1

Try this:

declare @x int, @y int, @f float
set @x = 100
set @y = 2000
set @f = @x / (@y * 1.0)
print @x
print @y
print @f

 

Answer 2

just try this

 

declare @a float,@b float
declare @c  float
set @a =cast(56278 as float)
set @b= cast(79089 as float)
set @c = @a / @b
print @a
print @b
print @c

 

Answer 3

What is happening is that you divide an integer value by another integer value => result is an integer. You can read up on this in BOL when you search for data type precedences (I think so). A simple way to prevent this is to use

 

set @f = @x * 1.0 / @y

Answer 4

 

just try this using cast

declare @a int,@b int
declare @C float
set @a = 100
set @b=200
set @c= cast(@a as float)/cast(@b as float)
print @C

Answer 5

set @f = @x*1.0 / @y*1.0