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

Last Reply 9 days ago By iammann

Posted 10 days 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 9 days ago.
Posted 9 days ago

THanks @pandeyism but i have resolved it by myself.

 

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