SQL converting nvchar to ntext

Question

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?

Answer 1

Is this a repeat of this: http://stackoverflow.com/questions/204170/how-to-update-a-text-or-ntext-field-in-sql-server-2000

The live table should use UPDATETEXT?

Answer 2

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.