SQL text字段内容合并 并加入分页字符串

DECLARE   @ptrval   binary(16) 
DECLARE   @ptrAdd   binary(16) 
DECLARE   @MessID   int
DECLARE   @pageStr  Nvarchar(200)
set @pageStr=' <div style="page-break-after: always"><span style="display: none"> </span></div> '

DECLARE MM_cursor CURSOR
FOR
 SELECT MessageID,TEXTPTR(Content) as Contentaddr FROM News_Article
 where MessageID in (select MessageID From MessagePage group by MessageID having count(*)>1)

OPEN MM_cursor
FETCH NEXT FROM MM_cursor into @MessID,@ptrval  --主表

While(@@Fetch_Status=0) 
Begin
 --分页表数据
  DECLARE MP_cursor CURSOR
  FOR
   select TEXTPTR(Content) from MessagePage where MessageID =@MessID
  OPEN MP_cursor
  FETCH NEXT FROM MP_cursor into @ptrAdd  --分页数据
  While(@@Fetch_Status=0) 
  Begin --处理
PRINT @MessID
   UPDATETEXT News_Article.[Content] @ptrval null 0 @pageStr
   UPDATETEXT News_Article.[Content] @ptrval null 0 MessagePage.[Content] @ptrAdd
  FETCH NEXT FROM MP_cursor into @ptrAdd
  End
 CLOSE MP_cursor
 DEALLOCATE MP_cursor
Print 'p'
FETCH NEXT FROM MM_cursor into @MessID,@ptrval
End
CLOSE MM_cursor
DEALLOCATE MM_cursor