Earlier I wrote SQL SERVER – Challenge – Puzzle – Usage of FAST Hint and I did receive some good comments. Here is another question to tease your mind. Run following script and you will see that it will thrown an error.
DECLARE @mymoney MONEY;
SET @mymoney = 12345.67;
SELECT CAST(@mymoney AS DECIMAL(5,2)) MoneyInt;
GO
The datatype of money is also visually look similar to the decimal, why it would throw following error:
Msg 8115, Level 16, State 8, Line 3
Arithmetic overflow error converting money to data type numeric.
Please leave a comment with explanation and I will post a your answer on this blog with due credit.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
28 Comments. Leave new
Buena respuesta, me sirvio
Its Working sir thank u .