¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£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") &")
Ïà¹ØÎÊ´ð£º
ÓÐ沒ÓÐ辦·¨實現£¬從MSSQL2000Æó業¹ÜÀíÆ÷註冊MSSQL2008數據庫£¿
Á¬²»ÉϰÉ
Ã²ËÆ沒Ï£Íû¡£¡£¡£
Ó¦¸ÃÊDz»ÐÐµÄ ¿çÌ«¶àÁË
ÄÇ2000µÄ ......
ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......
cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐ ......
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..
ÄÇÓÐûÓÐϵͳ´ ......