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

¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£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="&rs("big"))


ΪʲôÎÒʹÓÃRS£¨¡°big¡±£©¾Í»á³ö´í¡£¶øÖ±½ÓʹÓÃÈçid=1ÕâÑùµÄ²éѯÌõ¼þ¾Í²»»á´í°¡¡£ÒÔÇ°ÓõÄÊÇACCESSû´í¡£½ñÌìÎҸĻ»³ÉMSSQL¾Í³ö´í°¡¡£ºÃ¼¸¸öµØ·½¶¼ÊÇÕâÑùµÄÎÊÌ⣡

°ÑIDת»»Ï ת»»³É×Ö·û´®¸ñʽµÄ

IDºÍBIGµÄ¸ñʽ¶¼ÊÇINTµÄ°¡

Dim rs1:Set rs1=key28.exe("select [class] from [lm_class] where id="& rs("big") &")


Ïà¹ØÎÊ´ð£º

vc²Ù×÷mssqlһСÎÊÌâ

ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......

mssqlºÃ¶à±í¶¼"Ö»¶Á"

×î½üÏÂÃ淴Ӧ˵³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôԭÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
Ë­½â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?

ÒýÓÃ
×î½üÏÂÃæ ......

MSSQLÖÐÈçºÎÑ¡ÔñÒ»ÐÐÖÐ×îСµÄʱ¼ä£¿

Ò»ÕÅ±í£¬×ֶηÖΪid,time1,time2,time3,time4,time5 
ÇëÎÊÎÒÓ¦¸ÃÈçºÎÑ¡ÔñIDΪ1µÄÄÇÌõ¼Ç¼ÖÐtimeʱ¼ä×îСµÄÖµÄØ£¿
UP!

[code=SQL][/code]select min(t) from 
(select time1 as t from t1 where id ......

accessת»»mssqlºó²éѯºÜÂý

accessʱ²éѯËٶȻ¹Âù¿ìµÄ£¬ÏÖÔÚת³ÉmssqlÁË£¬Êý¾ÝÁ¿²¢²»´ó£¬Í¨³£Êý¾ÝÁ¿¶àЩµÄ¾ÍÊǼ¸Ç§Ìõ£¬µ±È«²¿ÁгöÊý¾ÝʱËÙ¶ÈÒ²²»Âý£¬¾ÍÊÇ°´Ìõ¼þËÑË÷ʱ¾ÍÂýÁË£¬ÇëÎÊÊDz»ÊǸúlikeÓйذ¡£¬µ«ÒÔÇ°ÓÃaccessÂù¿ìµÄ°¡£¬Ò²½¨Á¢ÁËË÷ÒýÁË ......

²éѯmssql´óÅúÁ¿Êý¾Ý

Êý¾Ý¿âÄÚÓÐ500WÌõÊý¾Ý£¬²éѯµÄʱºòÈçºÎÓÅ»¯
Õâ¶Îʱ¼äÒ²ÔÚ¿´SQL.ÎÒ¾õµÃÕâÁ½±¾Êé²»´í!SQLÒÕÊõ,SQL2008¼¼ÊõÄÚÄ» T-SQL»ù´¡.

ȷʵдһÌõ¸ßЧµÄSQL²»ÊÇÈÝÒ×µÄÊÂ!ÎҼǵÃ×îÇå³þµÄÒ»ÌõÊÇ:×î½ü¹ýÂ˵ô²»·ûºÏÌõ¼þµÄ¼Ç¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ