Is there a way to cast float as a decimal without rounding and preserving its precision

Question

So it appears that if you  CAST field1 as decimal  field1   this will automatically add rounding    The original is defined as   field1  type float  length 8    prec 53  I need to cast it to decimal  because I need my Entity Framework layer to generate this field as decimal  instead of double    Is there a way to cast it as decimal  so that it preserves original precision  and doesn t round    I would like to avoid having to declare the precision in the cast  because    there are 100 s of fields involved with varying precision  and  if the underlying table changes in the future  it could cause unforeseen bugs to emerge  and  makes the management more difficult

User · Answer

cast  field1 as decimal 53 8    field 1   The default is  decimal 18 0

User · Answer

Try SELECT CAST field1 AS DECIMAL 10 2   field1 and replace 10 2 with whatever precision you need

User · Answer

Have you tried   SELECT Cast  2 555 as decimal 53 8     This would return 2 55500000   Is that what you want   UPDATE   Apparently you can also use SQL VARIANT PROPERTY to find the precision and scale of a value   Example   SELECT SQL VARIANT PROPERTY Cast  2 555 as decimal 8 7    Precision    SQL VARIANT PROPERTY Cast  2 555 as decimal 8 7    Scale     returns 8 7  You may be able to use this in your conversion process

[sql] Is there a way to cast float as a decimal without rounding and preserving its precision?

Examples related to sql

Examples related to sql-server

Examples related to casting