Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tshaw20832
Starting Member
10 Posts |
 Posted - 2014-07-15 : 12:05:14
|
| All,I need to change a data type from vchar to text. Do you see any possible problems with doing this change? Also, will the present data be converted?Thank you very much,T |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2014-07-15 : 13:05:20
|
| Unless you're still on SQL 2000 (or, yikes, before), you should definitely use varchar(max). Text is a major hassle to update especially. |
 |
|
|
|
|
|
Changing Data Types on a column