Home Forums SQL Server 2014 Development - SQL Server 2014 Cast Varchar to Float Resulting In (Scientific) E Notation RE: Cast Varchar to Float Resulting In (Scientific) E Notation

  • August 26, 2016 at 2:12 am

    #1897727

    Ok, I must admit, I've not seen such am alarming example of float mathematics going wrong before. This is kinda scary.

    While I have your attention though... how do you get around the decimal rounding problem:

    declare @a decimal (38,28) = 1.123456789

    declare @b-2 decimal (38,28) = 1.123456789

    declare @C decimal (38,28) = 1.123456789

    select @a * @b-2 * @C

    ?