How to switch from VARCHAR to TEXT in SQL 2000?
Posted
by MatthewMartin
on Stack Overflow
See other posts from Stack Overflow
or by MatthewMartin
Published on 2010-04-30T18:24:29Z
Indexed on
2010/04/30
18:27 UTC
Read the original article
Hit count: 244
sql-server
|sql-server-2000
What do I need to consider before I switch a bunch of fields from VARCHAR(bignumber) to TEXT?
Aside from performance, and sometime in the far future TEXT will be deprecated, and aside from the fact that it looks like I need to drop and recreate the table to alter the column's data type?
This is for SQL 2000-- I can't do VARCHAR(max) and VARCHAR(8000) isn't large enough.
© Stack Overflow or respective owner
