• Hugo Kornelis (8/24/2010)


    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.

    i m still getting the error in sql server 2008... :unsure:

    compatibility level - 100...

    Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (X64) Enterprise Edition (64-bit)