sql server - How to change the data type of a column with query? - Stack Overflow

If ALTER COLUMN doesn't work. It is not unusual for alter column to fail because it cannot make the transformation you desire. In this case, the solution is to create a dummy table TableName_tmp, copy the data over with your specialized transformation in

stackoverflow.com