Parameter value '33.42922222' is out of range

Question

I have an attribute of a table named ad Latitude, i have set its `data type` as `decimal(9,8) null` but when i try to insert the value `33.42922222` it gives me the error Parameter value '33.42922222' is out of range. when i try to directly enter the value in the database table it gives the `Arithmetic overflow error` i have tried to change the datatype to `numeric(9,8) null` but to no avail please help me find out the problem ...

Accepted Answer

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

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

decimal and numeric (Transact-SQL)

Parameter value '33.42922222' is out of range

Solution

Problem