DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(InfoTxt) from U_info where id <> 14 UPDATETEXT U_info.InfoTxt @ptrval null 0 'aaa'
updata tableName set infoTxt=infoTxt+¡°aaa¡± where id ¡¶¡·14 ¼± ¼± À´ÈËѽ!! Çë½Ì ¼±??? SQL code: update U_info set InfoTxt = InfoTxt +'aaa' where id <> 14 ;
updata tableName set infoTxt=infoTxt+'aaa' where id<>14
select @ptrval=textptr(infoTxt) from tableName where Ìõ¼þ if(textvalid('tableName.infoTxt',@ptrval)=1) updatetext tableName.infoTxt @ptrval 0 null @infoTxt
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......