Arithmetic overflow error converting float to data type numeric in SQL Server

Last Reply 5 months ago By iammann

Posted 5 months ago

93060000.000000 i want to update this value in my table where datatype of column is decimal(18,13)

93060000.000000 is float type

i am getting this error

Arithmetic overflow error converting float to data type numeric.

You are viewing reply posted by: iammann 5 months ago.
Posted 5 months ago

THanks @pandeyism but i have resolved it by myself.

 

I have just changed column datatype capacity 18,13 to 25,13