ÖØÆô·þÎñÆ÷£¬MSSQLÖÐijһÊý¾Ý¿âËÀ
ÏÖÏóÈçÏ£ºÖØÆôÒ»Êý¾Ý¿â·þÎñÆ÷£¨windows2003+MSSQL2000£©ºó£¬ÆäÖÐÒ»Êý¾Ý¿âÁ¬½Ó²»ÉÏ¡£´ËʱÆäËüÊý¾Ý¿âÔËÐÐÕý³£¡£ÎÒʹÓÃMSSQL2008Ô¶³ÌÁ¬ÉÏÊý¾Ý¿â£¬É¾³ý´ËÊý¾Ý¿âºó£¬Ê¹Óø½¼ÓÊý¾Ý¿âÖØÐÂÌí¼ÓÉÏЩÊý¾Ý¿âºó¾ÍÄÜÕý³£Ê¹ÓᣴËÎÊÌâÒѳöÏÖ¹ý¶þ´Î¡£Êý¾Ý¿âMDFÎļþ´óÔ¼2G£¬ÈÕÖ¾Îļþ½Ï´ó£¬ÓÐ45G¡£Õâ¸öÇé¿ö´ó¼Ò°ï·ÖÎöÏ£¬ÓпÉÒÔ»áÊÇʲôÎÊÌ⣿
¶÷£¬ºÃµÄ£¬ÎÒÈ¥ÊÔÊÔ¿´¡£
{{----
Ïà¹ØÎÊ´ð£º
ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL
ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£
Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£
Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYS ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......
Dim Rs:Set rs=key28.exe("select [id],[big],[class] from lm_small")
Do while not rs.eof
Dim rs1:Set rs1=key28.exe("select [class] from [lm_class] where id="& ......
ÎÒÓÃ("insert into LM_info ([content],[date],[username]) values ('"&content&"',date(),'"&username&"')")
ÊÇ´íÎóµÄ¡£
µ«ÊÇÎÒÓÃgetdat ......