Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇósqlÓï¾ä

ÁªÏµÈË£ºÕźÏÀí </FONT> </P> <P> <FONT style="FONT-SIZE: 30px; FONT-FAMILY: ¿¬Ìå_GB2312">µç»°£º13512566019£»83855777 </FONT>

±ä³É£º
ÁªÏµÈË£ºÕźÏÀí </FONT> </P> <P> <FONT style="FONT-SIZE: 30px; FONT-FAMILY: ¿¬Ìå_GB2312">µç»°£º13512566019£»83855777 </FONT>

»ÒÉ«ÇøÓòÈ¥µô£¡

tb ±í £¨fd1£©


update  tb  set  fd1=...


¿¬Ìå_GB2312">ÁªÏµÈË£ºÕźÏÀí </FONT> </P> <P> <FONT style="FONT-SIZE: 30px; FONT-FAMILY: ¿¬Ìå_GB2312">µç»°£º13512566019£»83855777 </FONT> </P>



http://www.shuangyongjulebu.com/yikatong/Bulletin.aspx?bl_Id=5432
Ä¿±ê£º ÒªÈà ÁªÏµÈË £¬µç»°Ïûʧ

ÓкܶàÕâÑùµÄ¶ÎÂ䣬»¹ÊÇÖ»ÓÐÕâÁ½¸ö£¿

SQL code:
update tb set fd1=replace(replace(fd1,'ÁªÏµÈË£ºÕźÏÀí',''),'µç»°£º13512566019£»83855777','')


replaceÌæ»»µô¾ÍºÃÁË¡£

many£¡£¡£¡

<P> <FONT style="FONT-SIZE: 30px; FONT-FAMILY: ¿¬Ìå_GB2312">ÕÛ¿Û£º&nbsp; 9.5ÕÛ </FONT> </P> <P> <FONT style="FONT-SIZE: 30px; FONT-FAMILY: ¿¬Ìå_GB2312">µØÖ·£º&nbsp;·į̈·¸»ÀöÉÌÒµ½Ö4ºÅÂ¥ </FONT> </P> <P> <FONT style="FONT-SIZE: 30px;


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ