ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ
°ï¶¥
È¥ÍøÉÏÕÒÏÂÄÇÖÖÓÐÁ÷³ÌµÄÊý¾Ý¿âϵͳ ¶¼²î²»¶àµÄ
ÒýÓÃ
ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ
¼Ó¸ö×Ö¶Î,±ê¼ÇÔÚʲô״̬¼´¿É.
Óг¥¿ª·¢¡¢Éè¼ÆÖ§³Ö£¬Ìṩ³ÖÐøµÄ·þÎñ
ÔÎËÀ...
Á¢¼´¸ÄÃÜÂë...
ÕâôûƷµÄÌû×ÓÒ²·¢³öÀ´£¬º¹¡¡
ÒÔºóËÒªÃÜÂ붼²»¸øÁË...
ÎÒµÄ×ÊÔ´ ......
ʹÓÃÓï¾ä
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
  ......