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 '你想追加的内容'
转载于:https://www.cnblogs.com/chenyebin/archive/2010/05/27/1745316.html