Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÖØÆô·þÎñÆ÷£¬MSSQLÖÐijһÊý¾Ý¿âËÀ

ÏÖÏóÈçÏ£ºÖØÆôÒ»Êý¾Ý¿â·þÎñÆ÷£¨windows2003+MSSQL2000£©ºó£¬ÆäÖÐÒ»Êý¾Ý¿âÁ¬½Ó²»ÉÏ¡£´ËʱÆäËüÊý¾Ý¿âÔËÐÐÕý³£¡£ÎÒʹÓÃMSSQL2008Ô¶³ÌÁ¬ÉÏÊý¾Ý¿â£¬É¾³ý´ËÊý¾Ý¿âºó£¬Ê¹Óø½¼ÓÊý¾Ý¿âÖØÐÂÌí¼ÓÉÏЩÊý¾Ý¿âºó¾ÍÄÜÕý³£Ê¹ÓᣴËÎÊÌâÒѳöÏÖ¹ý¶þ´Î¡£Êý¾Ý¿âMDFÎļþ´óÔ¼2G£¬ÈÕÖ¾Îļþ½Ï´ó£¬ÓÐ45G¡£Õâ¸öÇé¿ö´ó¼Ò°ï·ÖÎöÏ£¬ÓпÉÒÔ»áÊÇʲôÎÊÌ⣿

¶÷£¬ºÃµÄ£¬ÎÒÈ¥ÊÔÊÔ¿´¡£
{{----


Ïà¹ØÎÊ´ð£º

MSSQL ת»» MYSQL

ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL
ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£

Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£

Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYS ......

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

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

±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......

Âé·³´óϺÃǰïæдһ¸öMSSQLµÄ´¥·¢Æ÷£¬¼±ÓÃ

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

±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......

¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£MSSQL²éѯÎÊÌâ

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="& ......

mssql ÈçºÎ¼Èë 2008-1-1 ÕâÑùµÄʱ¼ä¸ñʽ

ÎÒÓÃ("insert into LM_info ([content],[date],[username]) values ('"&content&"',date(),'"&username&"')")
ÊÇ´íÎóµÄ¡£

µ«ÊÇÎÒÓÃgetdat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ