sqlserver 追加text类型的字段内容

    DECLARE @ptrval binary(16)
    SELECT @ptrval = TEXTPTR(body) from emailsendlog
    WHERE PROJ_ID IN (SELECT PROJ_ID FROM INSERTED)
    UPDATETEXT emailsendlog.BODY @ptrval null 0 '你想追加的内容'