¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£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") &")
Ïà¹ØÎÊ´ð£º
ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......
ÓÐ沒ÓÐ辦·¨實現£¬從MSSQL2000Æó業¹ÜÀíÆ÷註冊MSSQL2008數據庫£¿
Á¬²»ÉϰÉ
Ã²ËÆ沒Ï£Íû¡£¡£¡£
Ó¦¸ÃÊDz»ÐÐµÄ ¿çÌ«¶àÁË
ÄÇ2000µÄ ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......
ÒѾ¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£
ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......