$ curl cheat.sh/

--  The only reliable way to do this will be using a temporary table, but
--  it will not be much SQL:

 select * into #tmp from bad_table
 truncate table bad_table
 alter bad_table alter column silly_column int
 insert bad_table
 select cast(silly_column as int), other_columns
 from #tmp
 drop table #tmp

--  [cjk] [so/q/577712] [cc by-sa 3.0]

$

Follow @igor_chubin cheat.sh