I have a
decimal(4, 4) column in MS SQL Server 2008 R2. If I understand correctly, that means:
Precisionof 4, ie up to four digits can be stored after the decimal place
Scaleof 4, ie a a total of four digits can be stored
When I run an update command to set the column to
update myTable set myDecimalColumn=1), I get this error:
Arithmetic overflow error converting numeric to data type numeric.
I don't understand how that is true.
1 has no digits after the decimal and is only one digit long.