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 7:05 am

    #1210983

    paul.knibbs (8/24/2010)

    Nope, just tested it on a SQL 2008 Express install and it came up with an arithmetic overflow as expected.

    Super! Thanks for testing and reporting back here.

    Obviously, this weird behaviour that appears to be exclusive to the ROUND() function has been fixed in SQL Server 2008.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/