Is there a way to transfer ntext data from one table to another? MSSQL2000

Is there a way to transfer ntext data from one table to another?

I tried this

UPDATE [projects]

SET [description] = (SELECT [description_ntext] FROM [table] WHERE
[id]=1)

WHERE [id_project] = 1;


and this

DECLARE @DESCRIPTION ntext

SET @DESCRIPTION = (SELECT [bids].[bid_conditions] FROM [bids],
[projects] WHERE [bid_accepted_id] = [bids].[id_bid] AND [id_project] =
@ID_PROJECT);

UPDATE [projects]

SET [description] = @DESCRIPTION

WHERE [id_project] = 1;



none of those work in MSSQL2K,
error reported is "The text, ntext, and image data types are invalid
for local variables."

.

Relevant Pages

  • Re: Cursor and Procedure
    ... I need to truncate those strings to the segments with 200 ... Actually problem is ntext hold> 4000 char. ... DECLARE @deptTriDes ntext ...
    (comp.databases.ms-sqlserver)
  • Re: Urgent Converting varchar to ntext in SQL
    ... The DataType is ntext for the Column "Notes" in Database. ... Do u know how to declare the local variable ... I tried declaring the "LocalNotes" as ntext, ... Sileesh ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: problem using ntext data type in OPENXML
    ... > I've got problems using ntext data in a stored procedure (SQL-Server ... > declare @Param ntext ... declare ntext variables - see DECLARE in Books Online. ...
    (microsoft.public.sqlserver.xml)
  • why doesnt this query work...
    ... declare @joiningTable varchar ... JournalJoiningTablesTypes left outer join JournalEntryTypes on ... JunctionTableName = @joiningTable) ... The text, ntext, and image data types are invalid in this subquery or ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing XML between 2005 and 2000
    ... create proc dbo.GetIDs(@p ntext) ... declare @x xml ...
    (microsoft.public.sqlserver.xml)