MS SQL 2012 - How to Fix Error - Arithmetic overflow error converting int to data type numeric.

Watch this example on YouTube:


The following sql statement will produce error
Select CONVERT (decimal(5 , 2), 1111)
Arithmetic overflow error converting int to data type numeric.

This is because 1111 is too large
To fix increase the size
Select CONVERT (decimal(10 , 2), 1111)