SQL 怬
ÎÒÃÇÏÖÔÚʹÓÃSCM£¬ÐèÒª°²×°Ò»¸öÁÙʱ·þÎñÆ÷¡£·þÎñÆ÷µÄSERVER 2003ÒѾ°²×°ºÃÁË¡£°²×°SQL2008µÄʱºò£¬ÎÒ´´½¨µÄʵÀýÃûΪXINXING¡£Õý³£°²×°Íê³Éºó£¬ÏÖÔÚ¿ÉÒÔÓÃXINXINGÕý³£µÇ¼¡£
¿ÉSCMÐèÒªÔÚÍøÂçÉϵǼ£¬ÎÒÏë°ÑXINXINGµÇ¼Ãû¸Ä³ÉIP£¨192.168.1.23£©½øÐеǼ£¬ÏÖÔÚÊÔÁ˺ö෽·¨£¬¶¼²»ÄÜÍê³É¡£
¹òÇë¸ßÊÖ£¬ÈçºÎ½«ÊµÀýÃûÐÞÕý£¬ÐÞÕýÍêºóÓÃIP½øÐеǼ¡£²»Ê¤¸Ð¼¤£¡£¡£¡£¡
²»¶®£¬°ïÄã¶¥Ò»ÏÂ
ÆôÓÃtcp/ipÐÒé
²Î¿¼£º
http://school.itzcn.com/special-spid-48.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£
²Î¿¼£º
http://school.itzcn.com/special-spid-48.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£
ÔÚ·þÎñÆ÷µÄÊôÐÔ ÍøÂçÉèÖÃÀïÃæ ÆôÓÃtcp/ipÐÒé ºÍÃüÃû¹ÜµÀ
Õâ¸öÎÊÌâÎÒÒ²Óöµ½¹ý£¬²»¹ýÎÒÊÇÔÚSQL Server 2005Óöµ½µÄ
Â¥Ö÷¿ÉÒԲο¼ÎÒµÄ×ö·¨¡£
1.¿ªÊ¼—SQL Server 2005-SQL ÅäÖùÜÀíÆ÷—SQL ServerÍøÂçÅäÖ×MySQLµÄÐÒé—ÓÒ»÷'TCP/IP'—ÆôÓÃ
2.Ë«»÷TCP/IP½øÈ¥—IPµØÖ·—ÌîдIP1ºÍIP2µÄIPµØÖ·—ÌîдIP1ºÍIP2µÄ¶¯Ì¬¶Ë¿ÚΪ0£¬IPALLµÄ¶¯Ì¬¶Ë¿Ú²»Ìî—ÌîдTCP¶Ë¿ÚΪ1433—IP1ºÍIP2µÄ»î¶¯ºÍÆôÓÃΪ'ÊÇ'
3.¿ªÊ¼—SQL Server 2005-SQL ÍâΧӦÓÃÅäÖùÜÀíÆ÷—·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷—Ô¶³ÌÁ¬½Ó—µã»÷'ͬÊÇʹÓÃTCP/IPºÍname pipes'
4.Ã²ËÆÔÚ³ÌÐòÓÃADOÁ¬½ÓÊý¾Ý¿âÖУ¬²ÉÓÃIPÁ¬½ÓºÍ²ÉÓÃÃüÃû¹ÜµÀÁ¬½ÓµÄÇý¶¯ÊDz»Ò»ÑùµÄ£¬Á¬½Ó´®Ò²¾Í²»Ò»ÑùÁË
Çë×¢Òâ·À»ðǽһ¶¨ÒªÆÁ±Î
¶¥£¬Ã»Óöµ½¹ýÕâÑùµÄÎÊÌ⣬ѧϰÏÂ
ÍÛ£¬ºÃ¶à£¬markÒ»°Ñ
¸öÈ˸оõ£¬Ê¹ÓÃIP½øÐж¨Î»sql
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......