开发者

SQL converting nvchar to ntext

What I have is a 开发者_开发百科staging table that is all nvarchar (so i can load it easily). In my live table i have a bunch of ntext items. I have the following:

obviously this isnt the whole query:

update
     SLTDS_C69_Stdtable
set
    [AARIssue] = convert(ntext, st.[AARIssue]),
    [AttachmentIDs] = convert (ntext, st.[AttachmentIDs])

I get this error returned:

types ntext and nvarchar are incompatible in the equal to operator.

ANy idea how to fix this?


Do you want to replace the text or add to it?

INthe first case you don't need to convert at all, just set the filed to the value of the filed inthe other table. INthe second case you need to use UPDATE text.

However, you have a problem in that ntext is deprecated, you should consider converting these fields to nvarchar(max) as soon as possible unless you are still running SQL Server 2000.


Is this a repeat of this: How to update a text or ntext field in SQL Server 2000

The live table should use UPDATETEXT?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜