ʵÏÖSQLÖÐJOINÁª½Ó¶à¸ö±í²éѯ
Ê×ÏÈ˵¸ö¼òµ¥µÄ£¬Á½¸ö±í²éѯ£º
¡¡¡¡ÓÐÁ½¸ö±í£¬ÎÄÕ±íÖÐTypeId×ֶμǼÀ¸Ä¿Id£¬À¸Ä¿±íÖеÄ×Ö¶ÎÊÇÀ¸Ä¿IdºÍÀ¸Ä¿Ãû£¬ÏÖÔÚÒª´ïµ½µÄЧ¹û¾ÍÊǶÁÈ¡ÎÄÕÂÁбíµÄʱºòÏÔʾÀ¸Ä¿Ãû³Æ¡£
¡¡¡¡ÒÔǰûÓùýinner
joinÍâÁª²Ù×÷£¬ËùÒÔ¾ÍÊøÊÖÎÞ²ßÁË¡£ÆäʵÓÐЩ¹¦ÄÜÊǽö½ö¿¿SQLÓï¾ä¾Í¿ÉÒÔʵÏֵģ¬inner
joinÄܹ»×éºÏÁ½¸ö±íÖеļǼ£¬Ö»ÒªÔÚ¹«¹²×Ö¶ÎÖ®ÖÐÓÐÏà·ûµÄÖµ¡£
¡¡¡¡ËùÒÔÒªÏÔʾÀ¸Ä¿Ãû³Æ£¬Ö»ÒªÓÃÈçÏÂSQLÓï¾ä£º
¡¡¡¡Select
[Article].id,[Article].content,[À¸Ä¿±í].[À¸Ä¿Ãû³Æ] from [Article] inner join [À¸Ä¿±í] on
[À¸Ä¿±í].id=[Article].ArType orDER BY [ArId]
DESC
¶à¸ö±í£¨¶àÓÚÁ½¸ö±íµÄÁª½Ó²éѯ£©ÊµÏÖ£º
¸½Ïà¹ØÎÄÕ£º
¡¡¡¡¶à±íÁª½Ó½¨Á¢¼Ç¼¼¯ÊÇÊ®·ÖÓÐÓõģ¬ÒòΪijЩÇé¿öÏ£¬ÎÒÃÇÐèÒª°ÑÊý×ÖÊý¾ÝÀàÐÍÏÔʾΪÏàÓ¦µÄÎı¾Ãû³Æ£¬Õâ¾ÍÓöµ½Á˶à±íÁª½Ó½¨Á¢¼Ç¼¼¯µÄÎÊÌâ¡£±ÈÈç×÷Ò»¸ö»áÔ±×¢²áϵͳ£¬¹²ÓÐÎå¸ö±í£¬»áÔ±ÐÅÏ¢Êý¾Ý±ímember¡¢»áÔ±Éí·Ý±íMemberIdentity¡¢»áԱȨÏÞ±í
MemberLevel¡¢»áÔ±Àà±ð±íMemberSortºÍ»áÔ±»éÒö×´¿ö±íWedlock¡£Èç¹ûÏë°Ñ»áÔ±×¢²áÐÅϢȫ²¿ÏÔʾ³öÀ´£¬¿Ï¶¨Òª½«ÕâËĸö±íÁ¬ÆðÀ´£¬·ñÔò´ó¼Ò¿´µ½µÄijЩ»áÔ±ÐÅÏ¢¿ÉÄÜÖ»ÊÇÊý¾Ý±àºÅ¡£
¡¡¡¡ÒÔ»áÔ±Àà±ð±íÀ´Ëµ£¬ÔÚÆäÊý¾Ý±íÖУ¬1´ú±íÆÕͨ»áÔ±£¬2´ú±í¸ß¼¶»áÔ±£¬3´ú±íÖÕÉí»áÔ±£¬ÔÚÏÔʾʱ£¬Èç¹û²»½«»áÔ±Àà±ð±íÓë»áÔ±ÏêϸÊý¾Ý±íÏà¹ØÁª£¬ÄÇô¼ÙÈçÎÒÃÇÏÖÔÚ¿´µ½µÄÊÇÒ»ÃûÆÕͨ»áÔ±µÄ×¢²áÐÅÏ¢£¬ÎÒÃÇÖ»ÄÜ¿´µ½ÆäÀà±ðΪ1£¬¶øËÓÖ»áÖªµÀ1´ú±íµÄÊÇÆÕͨ»áÔ±ÄØ£¿ËùÒÔÒª½«»áÔ±Àà±ð±íÓë»áÔ±ÏêϸÊý¾Ý±íÏà¹ØÁª£¬¹ØÁªºó£¬1¾ÍÏÔʾΪÆÕͨ»áÔ±£¬2¾ÍÏÔʾΪ¸ß¼¶»áÔ±£¬3¾ÍÏÔʾΪÖÕÉí»áÔ±£¬ÕâÑù¶àºÃ£¿Í¬Àí£¬ÆäËüÁ½¸ö±íÒ²ÒªÓë»áÔ±ÏêϸÊý¾Ý±íÏà¹ØÁª²ÅÄܰÑÊý¾Ý±àºÅÏÔʾΪÏàÓ¦µÄÃû³Æ¡£
¡¡¡¡Ç°ÌìÖÆ×÷ÍøÕ¾ºǫ́ʱÓöµ½´ËÎÊÌ⣬ÔÚÃæ°üÂÛ̳¡¢¿ñÃÔ¾ãÀÖ²¿¡¢À¶É«ÀíÏë¡¢ºÍ5D¶àýÌåÂÛ̳·¢ÁËÌù×ÓÇó¾È£¬¶¼Ã»ÓлñµÃ´ð°¸£¬Ö»ºÃ×Ô¼ºÑо¿£¬»¨ÁËÁ½Ììʱ¼äÖÕÓڳɹ¦£¬ÏÖ½«Æäд³É½Ì³Ì¹©´ó¼Ò·ÖÏí£¬Ï£Íû´ó¼ÒÉÙ×ßÍä·¡£
¡¡¡¡±¾½Ì³ÌÊǰÑÎå¸ö±íÁªÔÚÒ»Æð£¬Èç¹ûÔ¸Ò⣬Äú¿ÉÒÔ½«¸ü¶àµÄ±íÁªÔÚÒ»Æð£¬·½·¨´óͬСÒìÀ²~
¡¡¡¡²½ÖèÒ»£ºÓÃAccessÈí¼þ½¨Á¢Ò»¸öÃûΪMemberµÄÊý¾Ý¿â£¬ÔÚÆäÖн¨Îå¸ö±í£¬·Ö±ðΪ£º»áÔ±ÐÅÏ¢Êý¾Ý±ímember¡¢»áÔ±Éí·Ý±íMemberIdentity¡¢»áԱȨÏÞ±íMemberLevel¡¢»áÔ±Àà±ð±íMemberSortºÍ»áÔ±»éÒö×´¿ö±íWedlock¡£
¡ñ»áÔ±ÐÅÏ¢Êý¾Ý±íme
Ïà¹ØÎĵµ£º
ÎÒ¶¨ÒåÁËÒ»¸ö textarea:
<tr bgcolor="#CCCCCC" align="center" valign="bottom">
<td align="right" valign="top" class="style1" >ÎÄÕÂÄÚÈÝ£º</td>
&nbs ......
À´×Ô£ºhttp://www.cnblogs.com/morningwang/archive/2009/01/02/1367277.html
ÓйطÖÒ³ SQL µÄ×ÊÁϺܶ࣬ÓеÄʹÓô洢¹ý³Ì£¬ÓеÄʹÓÃÓαꡣ±¾È˲»Ï²»¶Ê¹ÓÃÓα꣬ÎÒ¾õµÃËüºÄ×Ê¡¢Ð§Âʵͣ»Ê¹Óô洢¹ý³ÌÊǸö²»´íµÄÑ¡Ôñ£¬ÒòΪ´æ´¢¹ý³ÌÊǾ¹ýÔ¤±àÒëµÄ£¬Ö´ÐÐЧÂʸߣ¬Ò²¸üÁé»î¡£ÏÈ¿´¿´µ¥Ìõ SQL Óï¾äµÄ·ÖÒ³ SQL °É¡£
·½·¨1£º
ÊÊÓÃ ......
1¡¢ÏÂÔØ±Ø±¸Èí¼þ
(1) JDK (Java Development Kit)
SUN¹Ù·½µÄÏÂÔØµØÖ·ÊÇhttp://java.sun.com/javase/downloads/index.jsp
(2) JDBC
(3) Eclipse
(4) Microsoft SQL Server 2005 Express£¨µ±È»£¬ÓзÇExpressÒ²OK°¡£©
(5) SQL Server Management Studio
2¡¢°²×°Óë»·¾³ÅäÖÃ
(1) JDK
Ê×ÏÈÔÚWindows»·¾³Ï£¬ÏÂÔØºó° ......
sql serverÑ¡ÔñÁË»ìºÏģʽÎÊÌâ
ÒòΪҪѡÔñ»ìºÏģʽ²ÅÄÜʹÓÃsaÓû§µÇ¼µÄÎÊÌâ
È»ºóÆóÒµ¹ÜÀíÆ÷ÀïÃæ¾¹È»Ñ¡ÁËÒÔºóûÓÐЧ¹û ÓÀÔ¶¶¼Êǽöwindowsģʽ
ÎÞÓï ²»¶ÏÖØÆômssql ÓÖÑ¡Ôñ »ìºÏģʽ ´óÔ¼¼¸·ÖÖÓºó¾¹È»¿ÉÒÔÑ¡ÔñÁË
zhenTMD µÄÎÞÄΣ¡ ......
--Excelµ¼ÈëSQL SERVERÖÐ
--±í½á¹¹²»´æÔÚ¿ÉÒÔʹÓÃ
--ÆôÓÃAd Hoc Distributed Queries£º
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
select * into serv_user_bak1 from
OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HDR=yes;dat ......