ʵÏÖ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
Ïà¹ØÎĵµ£º
1£ºSQL ServerÊý¾Ý¿âÅäÖÃ
¿ªÆô·þÎñÆ÷
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")rena ......
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»·¾³Ï£¬ÏÂÔØºó° ......
SELECT OrderId, TableName, replace(PrimaryKeyColumn,'''','''''') as PrimaryKeyColumn, ColumnState,cast(IsUpdating as varchar) as IsUpdating, OperateTime, ValueColumn, SystemTypeID from SubCompFtpDataDairy where OperateTime>=dateadd(hh,-24,getdate()) ......
Ò»¡¢Êý¾Ý¿â°æ±¾
Êý¾ÝѹËõÔÚSql Server 2008ÉϲÅÖ§³Ö£¬2005²»ÐУ¬²¢ÇÒ»¹ÒªÊÇÆóÒµ°æ¡£ÎÒ³£³£ÍüÁËÕâÒ»µã£¬ÔÚ2005µÄStudioÉÏÄÖ³öÓï·¨´íÎóµÄ×´¿ö£¬ÕÛÌÚÀË·ÑÁ˺ÃÒ»Õó²ÅÐÑÎò¹ýÀ´¡£
¶þ¡¢Ñ¹Ëõ×´¿ö
´óÔ¼¿ÉÒÔ½ÚÊ¡20%-50%µÄ¿Õ¼ä£¬²¢ÇÒÐÐѹËõºÍҳѹËõÓÐËùÇø±ð¡£
µ«ÈÃÎÒʧÍûµÄÊÇ£¬Ïñº¬ÓÐVarchar(max),xmlÕâÖÖ×Ö¶ÎÀàÐ͵쬷´¶øËƺõѹ ......