Friday, March 9, 2012

Division

I am trying the following SQL
declare @.var1 Float
set @.var1 = 1/2
select @.var1
I need @.var1 to be 0.5 instead of 0. Can you please let me know how I can get that?
Thanksdeclare @.var1 Float
set @.var1 = 1.0/2
select @.var1

or

declare @.var1 Float
set @.var1 = 1/2.0
select @.var1

or

declare @.var1 Float
set @.var1 = 1.0/2.0
select @.var1

int / int yields an int result!

No comments:

Post a Comment