SQL SERVER¾ÖÓòÍøÔ¶³ÌÁ¬½ÓÎÊÌâ
²Ù×÷ϵͳ£ºXP SP3
Êý¾Ý¿â£º SQL SERVER2000 ¸öÈ˰æSP4
ÎÊÌ⣺¾ÖÓòÍøÄÚÔ¶³ÌÁ¬½ÓSQL SERVERʱ£¬Ö»ÄÜͨ¹ýIPµØÖ·Á¬½Ó£¬ÎÞ·¨Í¨¹ý·þÎñÆ÷ÃûÁ¬½Ó£»PING IP¿ÉÒÔͨ£¬·þÎñÆ÷Ãû³Æ²»Í¨
"SERVER=lqg.;Initial Catalog=db_gj;Integrated Security=false;User Id=sa" Á¬½Óʧ°Ü
"Data Source=192.168.1.103;Initial Catalog=db_gj;Integrated Security=false;User Id=sa"Á¬½Ó³É¹¦
·þÎñÆ÷±¾µØÁ¬½Ó¶¼¿ÉÒԳɹ¦£¨Í¨¹ýIP»òÕß·þÎñÆ÷Ãû£©¡£
³õѧÊý¾Ý¿âÕߣ¬Íû´ó¼ÒÖ¸µ¼¡£
select * from opendatasource(sqlcilect='' database= userid= password=).數據庫¡£±íÃ÷
Ч¹ûÒ»Ñùô¡£
¿´¹ýÁË£¬µ«ÊÇÎÒµÄDNSÊÇ×Ô¶¯»ñÈ¡µÄ¡£IPµØÖ·Ò²ÊÇ¡£µ«ÊǺÃÏóûÈË˵Ϊʲô¾ÖÓòÍøÄÚΪʲôֻÄÜÓÃIPÁ¬½Ó£¬²»ÄÜÓ÷þÎñÆ÷ÃûÁ¬½Ó¡£°¥£¡£¡£¡ÎÒ¶¼ÔÚÍøÉÏÕÒÁ½ÌìÁË£¬ËÖªµÀ¿ì¸æËßÎÒ°¡¡£ÎÒµÄÍøÂçÊÇͨ¹ýÆäËûµçÄÔÉÏÍøµÄ£¬Ò²¾ÍÊÇͬʱ´æÔÚ¾ÖÓòÍøÓ뻥ÁªÍø¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......