ACCESS Êý¾Ý¿â²éѯµÄÎÊÌâ
ÈçÉÏͼ£¬Õâ¸öÊÇÎÒÔÚACCESSÊý¾Ý¿âÖн¨Á¢µÄÒ»¸ö²éѯ£¬±íÃûΪddcx
ÓÃsql="select * from ddcx order by id desc"
<%=rs("userid")%>¿ÉÒÔÏÔʾ£¬
µ«ÊÇÓÃ<%=rs("chanpin.name")%>ºÍ<%=rs("danhao.name")%>È´ÔõôҲÏÔʾ²»³öÀ´
ÓÐûÓиßÊÖ¸æËßÎÒΪʲôѽ£¿
ÓÑÇéÖ§³Ö
Â¥Éϵģ¬¿ÉÒÔÁË£¬ÇëÎÊÕâ¸öÊÇΪʲôѽ
×ֶδÓ0¿ªÊ¼£¬2¾ÍÊÇchanpin.name£¬ÓÐÖØÃû£¬×îºÃÓÃSELECT ASÈ¡±ðÃû
Ïà¹ØÎÊ´ð£º
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......