试试:
Using CAST:CAST ( expression AS data_type ) Using CONVERT:CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Using CAST:CAST ( expression AS data_type ) Using CONVERT:CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
调试欢乐多
UPDATE news
SET content = image + content
WHERE (image <> '')
报错信息为:Invalid operator for data type .Operator equals add,type equals ntext.我查的sql的帮助文件上这样说:如果要替换或修改大块的 text、ntext 或 image 数据,请使用 WRITETEXT 或 UPDATETEXT 语句而不要使用 UPDATE 语句。不知有谁用过updatetext语句?
具体实现代码如下:DECLARE Update_Cursor CURSOR FOR
SELECT newsid
FROM news9OPEN Update_Cursor
declare @newsid int
DECLARE @PtrVar BINARY(16)
DECLARE @InsertPos INT
DECLARE @DeleteLen INT
declare @c nvarchar(100)FETCH NEXT FROM Update_Cursor into @newsid
WHILE @@FETCH_STATUS = 0
BEGINSELECT @PtrVar = TEXTPTR(content),
@InsertPos = 0,
@DeleteLen = 0,
@c=image1
FROM news9
where newsid=@newsidUPDATETEXT news9.content
@PtrVar
@InsertPos
@DeleteLen
WITH LOG @cFETCH NEXT FROM Update_Cursor into @newsid
ENDCLOSE Update_Cursor
DEALLOCATE Update_Cursor