ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ
°ï¶¥
È¥ÍøÉÏÕÒÏÂÄÇÖÖÓÐÁ÷³ÌµÄÊý¾Ý¿âϵͳ ¶¼²î²»¶àµÄ
ÒýÓÃ 
 ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ 
  
 ¼Ó¸ö×Ö¶Î,±ê¼ÇÔÚʲô״̬¼´¿É.
Óг¥¿ª·¢¡¢Éè¼ÆÖ§³Ö£¬Ìṩ³ÖÐøµÄ·þÎñ
ÔÎËÀ... 
 Á¢¼´¸ÄÃÜÂë... 
 ÕâôûƷµÄÌû×ÓÒ²·¢³öÀ´£¬º¹¡¡
ÒÔºóËÒªÃÜÂë¶¼²»¸øÁË... 
 ÎÒµÄ×ÊÔ´ ......
    
        
    
    ʹÓÃÓï¾ä 
  
 SELECT * from OPENQUERY(MYSQL10 ,'select area_e_name,area_c_name,code from area' ) 
  
 ¿ÉÒԲ鿴µ½MYSQLÉϵÄÊý¾Ý.µ«Ð´ÈëÊý¾ÝµÄʱºò¾Í±¨´íÁË,Óï¾äÈçÏÂ: 
  
 insert openquery(MYSQL10,  'SELECT area_e_name,area_c_name,code from SearchEngineDataBase.dbo.Product_Search  ......
    
        
    
    ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if  
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸
Òª»ñµÃÊý¾Ý¿âÅ׳öµÄÒì³£»¹ÊÇ×Ô¶¨ÒåµÄÒì³£¡£¡££¿
Äã¿ÉÒÔ¸ù¾Ý err.Number À´ÅжÏÊÇ·ñÓÐ ......
    
        
    
    °²×°¹ý³Ìʱû³öÏÖ´íÎóÌáʾ¡£ Ò»Ö±µ½½áÊø£¬Ôò˵MSSQL û°²×°³É¹¦ 
  
 Summary.txt ÄÚÈÝÈçÏ£º 
  
 Overall summary: 
   Final result:                  ÒÑͨ¹ý 
   Exit code (Decimal):           0 
   Exit message:&n ......
    
        
    
    ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳһЩ´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯¸ôÀë¼¶±ð£¬ÓÐûÓкÃÒ»µãµÄ½â¾ö·½°¸
ÎÒÒªÇóÊä³ö@_Output INT
Êä³ö´óÓÚÁã±íʾ@@IDENTITY
µÈÓÚ0±íʾ´æÔÚÏàÍ ......
    
        
    
    ±íµÄ½á¹¹ÈçÏ£º 
  
 ±í1£ºtb_big 
 ×ֶΣºfalseid Öµ£º1£¬2£¬ 
 ×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£© 
  
 ±í2£ºtb_small 
 ×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµÄ£© Öµ£º1£¬1£¬1£¬2£¬2£¬2 
 ×ֶΣºsmalltype Öµ£ºa1£¬a2£¬a3£¬b1£¬b2£¬b3 
         ......