I am trying to use builtin ROUND function in SQLServer2005 in our project.
I tried the function first on how it works, I use 9.5 as the numeric expression(1st parameter of the function) and 0 as the length(2nd parameter). I get an error message saying "An error occurred while executing batch. Error message is: Arithmetic Overflow."..
I tried 9 (as 1st parameter) with decimal places less than 5 (e.g. 9.4, 9.3...) it works well..
I tried again 9 (as 1st parameter) with higher decimal places (eg. 9.6,9.7...) I got same error message.
I tried again with other numbers like 99.5, 99.6, 999.5, 9999.5....and so on, same error message went up... But when I tried other numbers it worked well..
Examples of working statements:
Examples of non-working statements:
Thank you, and More power!!!