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 |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2010-09-29 : 01:56:53
|
| Dear All,update tbl1 set content=(select content from tbl1 where id=3) where id in (4,5,6,8,9,11)content is nText field. I getting error:- The text, ntext, and image data types are invalid in this subquery or aggregate expression.Anyone have idea how to solved this issue.Thank you.Regards,Micheale |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
micnie_2020
Posting Yak Master
232 Posts |
Posted - 2010-09-29 : 03:00:08
|
Dear tkizer,I'm getting error The text, ntext, and image data types are invalid for local variables.Anyway. I get solution dyy. Answer isupdate a set content=b.content from tbl1 a inner join tbl1 b on b.id=3 where a.id in(4,5,6,8,9,11) Thank you.Regards,Micheale |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-29 : 03:02:36
|
| Can you change column to nVarchar(MAX) datatype instead? nText is deprecated and won't be supported in future versions, and nVarchar(MAX) allows string manipulations the same as ordinary nVarchar so is much more flexible. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
nText update issue