|
|
Posted by Igor on 08/29/06 12:47
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."
Navigation:
[Reply to this message]
|