Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.
Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).
select (5/7) always result 0 .... how can i correct this result ? plz help :(
SQL-Server assumed that you wanted an integer result because both of the operands were integers. Try: select convert(float, 5) / 7 Regards Andy
select convert(float, 5) / 7