ASPÊý¾Ý¿â²éѯÁ¬±íÎÊÌâ~~~~~~~~~
a±íÖÐÓвúÆ·±àºÅ£¬b±íÖÐÒ²ÓÐÓвúÆ·±àºÅ£¬ÏÖÔÚÁ½¸ö±íÁ¬ÔÚÒ»Æð£¬µ«Ö»ÐèÒªÒ»¸ö²úÆ·±àºÅµÄÁÐÃû£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖ£©~~~~~
ÄãÒªÔõôÁ¬£¿Ìõ¼þ¶¼Ã»Ëµ£¿2¸öIDÏàµÈΪÌõ¼þ£¿ ¶Ô~~ÒÔËûÃǵIJúÆ·±àºÅΪÌõ¼þ~~~ÊÇSQL2000µÄ~~£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖÁ¬½Ó·½·¨£©~~~~~ Ò²¾ÍÊÇ説Á¬½Óʱ°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô ¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·IDÒýÓà ¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID ¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~ ÒýÓà ÒýÓà 4 Â¥ chinmo µÄ»Ø¸´: ¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID ¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~ lzΪʲôÌáÈ¡Êý¾ÝµÄʱºò×ÜÓÃÕâÖÖ·½·¨ÄØ£¿ ÓÃlfet join ÒѾȷ¶¨ÁËÕâ¸ö²úÆ·idÊÇ´ÓA±íÖжÁÈ¡³öÀ´µÄ°¡£¿ û°ì·¨°¡~~ÀÏʦ¸øµÄÄÑÌâ~~Æäʵ~~ÎÒÒ²ÊÇͦÓôÃÆµÄ~~´ó¼Ò~·°ï°ïæßÂ~~~ ±äÁ¿ÊdzÌÐò²úÉ
Ïà¹ØÎÊ´ð£º
Îļþ£ºfolder.inc HTML code: <% Dim folderini,pos,pageName fPath = Request.ServerVariables("PATH_TRANSLATED") pos = instrRev(fPath,"\") folderini = Left(fPath,pos)+&qu ......
ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£ Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð? ²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ »¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É <% if ȨÏÞ=1 then %> <input type="submit" name="Submit" value="Ìá½»" /> <% end i ......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC) '=========================================================================== SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû S ......