Link to home
Start Free TrialLog in
Avatar of krimsonius
krimsonius

asked on

Float problem in SQL Server

Hi,

Why does this statement return 0 instead of 0.5?

SELECT
  (1/2)

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of imran_fast
imran_fast
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of imran_fast
imran_fast
Because the sql compiler treats it as an integer.