AI编程社区

DECLARE @ID INT
DECLARE UTEXT_CURSOR CURSOR FOR
SELECT ID FROM DBO.UPDATE_TEXT_TEST 
OPEN UTEXT_CURSOR
FETCH NEXT FROM UTEXT_CURSOR INTO @ID
WHILE @@FETCH_STATUS = 0  
BEGIN
    DECLARE @PTRVAL BINARY(16) --定义指针
    SELECT @PTRVAL = TEXTPTR([TEXT]) FROM UPDATE_TEXT_TEST WHERE ID = @ID
                                                               --设置指针
    DECLARE @INFORMATIONFORINSERT VARCHAR(8000)
    SELECT  @INFORMATIONFORINSERT= SUBSTRING([TEXT],0,8000) +'8888' FROM UPDATE_TEXT_TEST WHERE ID = @ID
    WRITETEXT UPDATE_TEXT_TEST.TEXT @PTRVAL @INFORMATIONFORINSERT         --保存信息
    FETCH NEXT FROM UTEXT_CURSOR INTO @ID
END    
CLOSE UTEXT_CURSOR                                        
DEALLOCATE UTEXT_CURSOR 

通过游标批量修改text类型的字段