C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ

  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ

 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×ֶΠÎı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ¶ø±ðµÄÐеÄInfoTxt ¶¼³ÉÁË""¿ÕµÄ 

Çë½ÌÇ°±²ÃÇ ÎÒÔõÑù×ö!!!!!!!!!!¼± ¼±

C# code:

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

---

ÒýÓÃ

select @ptrval=textptr(infoTxt) from tableName where Ìõ¼þ
if(textvalid('tableName.infoTxt',@ptrval)=1)
updatetext tableName.infoTxt @ptrval 0 null @infoTxt

ÕâÑù Ò²ÊÇ Ö»°É×îºóÒ»ÐÐ +ÁË 


&n