Arithmetic overflow error converting numeric to data type numeric

0
votes

i am having hard time determining the length of a Decimal data type. The data i have in column is like 0.08,1.2,12.35,121.36. Now if i go for (2,2) it throws an error : Arithmetic overflow error converting numeric to data type numeric. Just wondering should it be (6,2)? and if yes can anybody tell me Why 6 and 2?

2
sql

2 Answers

3
votes

In syntax like

NUMERIC(precision, scale)

precision is the total number of digits (count digits on both sides of the decimal point), and scale is the number of digits to the right of the decimal point.

0
votes

From your examples, should be NUMERIC(5,2) - meaning five numbers in total and 2 after the decimal point.