Loading

Fields in table doesn't accept 10 precisions

Ravikiran Suravarapu

7y785

One Field in my sql server which has decimal(10,10) datatype with precision values. While insert the data Ex:- 190.3456789034 it has 10 decimals , it will show an error "Airthmatic overflow error converting numeric to data type numeric".

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

amit kumar7y ago
Accepted answer
Your number is 190.3456789034. You can try with decimal(14,10).

Given to the type 'decimal' exceeds the maximum allowed (38)
Exa:
create table abc
(
price decimal(14,10)
)
insert into abc values(190.3456789034)

Output:
Madan Shekar7y ago
first try with decimal(11,2) or decimal(18,2)