Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Round up or down IV RE: Round up or down IV

  • August 24, 2010 at 5:24 am

    #1210933

    Hugo Kornelis (8/24/2010)

    Here is an interesting experiment (works on every client):

    SELECT ROUND(789.98,-3) AS WeirdCol

    INTO WeirdTable;

    go

    EXEC sp_help 'WeirdTable';

    go

    UPDATE WeirdTable

    SET WeirdCol = WeirdCol - 0.001;

    go

    DROP TABLE WeirdTable;

    go

    Hugo what is the expected result? On my system it's an empty table (nothing weird about the table though :cool:) and the update operates on 0 rows - therefore nothing is really happening further. Are you referring to the fact that the table gets created despite the arithmetic overflow?

    Regards,

    Hrvoje Piasevoli

    Hrvoje Piasevoli