When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS)
I tried:
select cast(3/4 as decimal(8,2)) example
but the result is
example
0.00
and the real value do not appear
When I tried do calculation where the result are in decimals, this are not displaying. (SQL EXPRESS)
I tried:
select cast(3/4 as decimal(8,2)) example
but the result is
example
0.00
and the real value do not appear
I´ve solved this:
select 3/cast(4 as float) as example