accessʱ²éѯËٶȻ¹Âù¿ìµÄ£¬ÏÖÔÚת³ÉmssqlÁË£¬Êý¾ÝÁ¿²¢²»´ó£¬Í¨³£Êý¾ÝÁ¿¶àЩµÄ¾ÍÊǼ¸Ç§Ìõ£¬µ±È«²¿ÁгöÊý¾ÝʱËÙ¶ÈÒ²²»Âý£¬¾ÍÊÇ°´Ìõ¼þËÑË÷ʱ¾ÍÂýÁË£¬ÇëÎÊÊDz»ÊǸúlikeÓйذ¡£¬µ«ÒÔÇ°ÓÃaccessÂù¿ìµÄ°¡£¬Ò²½¨Á¢ÁËË÷ÒýÁË
ÎÒlikeÊÇÕâÑùд·¨µÄ
sqlstr += " and hbh like '%" + bh + "%'";
......
Êý¾Ý¿âÄÚÓÐ500WÌõÊý¾Ý£¬²éѯµÄʱºòÈçºÎÓÅ»¯
Õâ¶Îʱ¼äÒ²ÔÚ¿´SQL.ÎÒ¾õµÃÕâÁ½±¾Êé²»´í!SQLÒÕÊõ,SQL2008¼¼ÊõÄÚÄ» T-SQL»ù´¡.
ȷʵдһÌõ¸ßЧµÄSQL²»ÊÇÈÝÒ×µÄÊÂ!ÎҼǵÃ×îÇå³þµÄÒ»ÌõÊÇ:×î½ü¹ýÂ˵ô²»·ûºÏÌõ¼þµÄ¼Ç¼
500W.......Õâ¸ö½á¹ûË¿´µÄÍê.
sqlÓï¾ä¸´ÔӵĻ°,½¨ÒéÓô洢¹ý³Ì. ÓÅ»¯Ã÷È·¾«È·µÄÊý¾Ý½á¹û½øÐвéѯ.
......
×ֶεÄĬÈÏÖµÔ¼ÊøÉúËùµÄÔ¼ÊøÃû³Æϵͳ³£³£ÔÚºóÃæÌíÉÏÒ»¸öËæ»úµÄ×Ö·û´®£¬
Èç
DF__Admin__locked__014935CB
ÕâÑùÔì³ÉÒÔºóÔÚÐ޸ĸÄÔ¼ÊøµÄʱºòºÜÂé·³£¬ÔõôÉèÖò»ÈÃÊý¾Ý¿â×Ô¶¯Éú³ÉÕâÑùµÄËæ»úÃû³ÆµÄÔ¼ÊøÃû³Æ
¶øÏòÕâÑù DF__Admin__locked
ÎÒÓõÄÊÇPDÉú³ÉµÄSQLÓï¾ä£¬Èç¹û¿ÉÒÔ£¬ÔÚPDÖÐÈçºÎÉèÖã¿
²»ÖªµÀ °ï¶¥
PD²»Çå³þ£¬ÄãÖ ......
cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË
Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ ......
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..
ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿
ÒýÓÃ
ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿
û
ÄÇͳ¼Æ· ......
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ÕâÑùµÄ²éѯÌõ¼ ......