[ACCEPTED]-Parameter value '33.42922222' is out of range-entity-framework

Accepted answer
Score: 21

For clarification DECIMAL(9,8) is 1 digit before the 2 decimal point and 8 digits after the decimal 1 point.

So DECIMAL(10,8) should work for 33.42922222.

decimal and numeric (Transact-SQL)

Score: 2

Your precision is not enough. Set precision according to the maximum 3 value which you except. For example, if 2 you expect 999,999 as the maximum value 1 and you need a scale of 8, set it as decimal(14,8).

More Related questions