Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʵÏÖ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


Ïà¹ØÎĵµ£º

SQLÓïÑÔ»ù´¡

SQL:Structured Query Language,1974ÄêBoyceºÍChamberlinÌá³ö.
Êý¾Ý¶¨Òå :CREATE,DROP
Êý¾Ý¿â²éѯ:SELECT
Êý¾Ý²Ù×Ý :INSERT,UPDATE,DELETE
Êý¾Ý¿ØÖÆ :GRANT,REVOKE
Ò».Êý¾ÝµÄ¶¨ÒåºÍÐÞ¸Ä:
1.¶¨Òå»ù±í
CREATE TABLE ±íÃû (<ÁÐÃû1 ÀàÐÍ[NOT NULL][,ÁÐÃû2 ÀàÐÍ[NOT NULL]>…[ÆäËû²ÎÊý]);
¹ØÓÚÀàÐÍ:
INTEGE ......

sqlÈÕÆÚº¯Êý

SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,
1.      µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
        select getdate()
2. dateadd      ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
       ÀýÈ ......

Sql Server»ù±¾º¯Êý

1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
space(int_expr) Éú³Éint_expr¸ö¿Õ¸ñ ......

SQL Server 2005 Driver for JDBC


Load the SQL Server 2005 Driver for JDBC before you load the SQL Server 2000 Driver for JDBC. To do this, use the DriverManager class as in the following code example.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version
Class.forName("com.microsoft.jdbc.sqlserver.SQLSe ......

Sql NewId() Ëæ»úÊý £¨×ª£©


´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úѡȡ¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ