comments edit

image Tonight I went in to add a column to one of my sql databases using GoDaddy’s SQL Server Web Admin.  This column happened to be a VarChar(Max).  Now when adding a varchar column, you have to enter an integer in the length column, so there is a VarCharMax field type.  Unfortunately, it doesn’t work.  Instead of creating a VarChar with Max as the length, it leaves it with a length of 1.  The solution is to change the column type via the Query Analyzer.  If you find yourself in this situation, run this query to update your column:

 

ALTER TABLE MyTable ALTER COLUMN MyColumn VarChar(MAX)

Happy SQLing.


Chris Risner