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

Giganews Newsgroups
Subject: Is there a way to transfer ntext data from one table to another? MSSQL2000
Posted by:  Igor (jerosim…@gmail.com)
Date: 29 Aug 2006

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."

Replies