What is the different b/w float and decimal type in sql server?

Vulpes15y ago

Accepted answer

Float is used for floating point numbers and the internal format used means that it's not necessarily exact.

Decimal, on the other hand, is for fixed precision numbers and is exact.

For percentages, I'd use decimal.

0

Vulpes15y ago

If you declare it as decimal(5, 2), to accommodate percentages up to 100.00, do you still get the error?

If you do, how are you making the conversion?

0

Nethra R S15y ago

@Vulpes,

As you said i am saving percentage values and the datatype declared for that is decimal(3,2) but when a user enters 10.3 for example it gives an error saying cannot convert varchar to decimal

0

Pravin More15y ago

Hi Nethra,

float data type is known as approximate data types.Approximate numeric data types do not store the exact values specified for many numbers they store an extremely close approximation of the value.do not use float when exact numeric behavior is required, such as in financial applications,

so decimal is perfect.

Thanks,
Pravin.

0