I'm currently trying to convert a column in SQL Server from nvarchar(255) to decimal(18,0). However, this is the error I get:
'member_details' table - Unable to modify table.
Error converting data type nvarchar to numeric.
Before this error, Management Studio gave a warning about changing the datatype of columns with many rows. My DB contains about 1,000,000 rows.
Can anybody help? Any help will be greatly appreciated.