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 |
|
calvin_nguyen
Starting Member
4 Posts |
 Posted - 2008-08-21 : 15:50:40
|
Hi,I have an old table with many rows. I need to convert a column from nvarchar(4000) to ntext due to storage needs. First time I've done this.Just wondering about impacts:- I understand query and update performance will be degraded, but I want to confirm this is only for operations that target the ntext column, not for any operation that hits the table.
- Certain functions will no longer work, right? What are the most common? Will UPDATE be okay? I expect I will need to go through all sprocs that access the newly converted column.
Thanks for your advice,Calvin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:18:42
|
| 1. shouldn't affect other columns in the table.2. can't use string functions on text column. |
 |
|
|
|
|
|
Convert nvarchar To ntext