How to use float in SQL for amount

Apr 12 2016 4:51 AM

Dear,

I have a field called T_Amount data type is float,

e.g= T_Amount=11800

When i make formula in query (11800/24)*35.25=17331.25

but actually if i make in calculator (11800/24)*35.25=17331.24999

i want this full figure.

Is i need to change the data type?

Answers (2)

insert, update store procedure in sqlserver

count product in sqlserver use PARTITION BY