SQL
SQL Int to Decimal Data Type - Alter Table
I had a problem recently when some automatic updates were not processing due to the data needing more decimal places.
I found a solution to change a field data type from Int to Decimal you can try this:
Alter table yourtable_
Alter Column yourtable_number Decimal(10,2)
The 2 numbers inside the brackets represent total 10 digits and in which 2 [...]