Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mssql

¹òÇó¹«ÎÄÉóÅúϵͳMSSQLÊý¾Ý¿â±í½á¹¹Éè¼Æ

ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ
°ï¶¥

È¥ÍøÉÏÕÒÏÂÄÇÖÖÓÐÁ÷³ÌµÄÊý¾Ý¿âϵͳ ¶¼²î²»¶àµÄ

ÒýÓÃ
ÈçÌâ ÓÐÆð²Ý ÉóºË »áÇ© ·¢ÎŦÄÜ

¼Ó¸ö×Ö¶Î,±ê¼ÇÔÚʲô״̬¼´¿É.

Óг¥¿ª·¢¡¢Éè¼ÆÖ§³Ö£¬Ìṩ³ÖÐøµÄ·þÎñ

ÔÎËÀ...
Á¢¼´¸ÄÃÜÂë...
ÕâôûƷµÄÌû×ÓÒ²·¢³öÀ´£¬º¹¡­¡­

ÒÔºóË­ÒªÃÜÂ붼²»¸øÁË...
ÎÒµÄ×ÊÔ´ ......

Á´½Ó·þÎñÆ÷Á´½ÓÓÉMSSQL2005ÖÁMYSQL£¬¿É²é¿´£¬Ð´Èë³ö´í

ʹÓÃÓï¾ä

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 &# ......

150·ÖÇóvbscriptÖÐÅжÏmssqlÓï·¨´íÎó

ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?


»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if 
else


²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïÑ°ÕÒ´ð°¸

ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïÑ°ÕÒ´ð°¸
Òª»ñµÃÊý¾Ý¿âÅ׳öµÄÒì³£»¹ÊÇ×Ô¶¨ÒåµÄÒì³£¡£¡££¿

Äã¿ÉÒÔ¸ù¾Ý err.Number À´ÅжÏÊÇ·ñÓÐ ......

MSSQL 2008 °²×°ÎÊÌâ

°²×°¹ý³Ìʱû³öÏÖ´íÎóÌáʾ¡£ Ò»Ö±µ½½áÊø£¬Ôò˵MSSQL û°²×°³É¹¦

Summary.txt ÄÚÈÝÈçÏ£º

Overall summary:
  Final result:                  ÒÑͨ¹ý
  Exit code (Decimal):          0
  Exit message:&n ......

MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET

ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖظ´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳ­Ò»Ð©´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯¸ôÀ뼶±ð£¬ÓÐûÓкÃÒ»µãµÄ½â¾ö·½°¸
ÎÒÒªÇóÊä³ö@_Output INT
Êä³ö´óÓÚÁã±íʾ@@IDENTITY
µÈÓÚ0±íʾ´æÔÚÏàÍ ......

ÔÚMSSQLÖÐдһ¸ö´¥·¢Æ÷

±íµÄ½á¹¹ÈçÏ£º

±í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
        ......
×ܼǼÊý:200; ×ÜÒ³Êý:34; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [10] [11] [12] [13] 14 [15] [16] [17] [18] [19]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ