title: In SQL Server change column of type int to type text
body: <p>I would like to change a column in SQL Server from type int, to type text, while maintaining the column name.  The table with this column has lots of data, and I do not want to lose it.  SQL Server doesn't seem to support implicit or explicit casts from int to text, otherwise this would be pretty simple.  So, how would you do it using only SQL?</p>