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

SQLÈý´ó·¶Ê¾

µÚÒ»·¶Ê½:È·±£Ã¿ÁеÄÔ­×ÓÐÔ.
Èç¹ûÿÁÐ(»òÕßÿ¸öÊôÐÔ)¶¼ÊDz»¿ÉÔÙ·ÖµÄ×îСÊý¾Ýµ¥Ôª(Ò²³ÆÎª×îСµÄÔ­×Óµ¥Ôª),ÔòÂú×ãµÚÒ»·¶Ê½.
ÀýÈç:¹Ë¿Í±í(ÐÕÃû¡¢±àºÅ¡¢µØÖ·¡¢……)ÆäÖÐ"µØÖ·"Áл¹¿ÉÒÔϸ·ÖΪ¹ú¼Ò¡¢Ê¡¡¢ÊС¢ÇøµÈ¡£
µÚ¶þ·¶Ê½:ÔÚµÚÒ»·¶Ê½µÄ»ù´¡Éϸü½øÒ»²ã,Ä¿±êÊÇÈ·±£±íÖеÄÿÁж¼ºÍÖ÷¼üÏà¹Ø.
Èç¹ûÒ»¸ö¹ØÏµÂú×ãµÚÒ»·¶Ê½,²¢ÇÒ³ýÁËÖ÷¼üÒÔÍâµÄÆäËüÁÐ,¶¼ÒÀÀµÓÚ¸ÃÖ÷¼ü,ÔòÂú×ãµÚ¶þ·¶Ê½.
ÀýÈç:¶©µ¥±í(¶©µ¥±àºÅ¡¢²úÆ·±àºÅ¡¢¶¨¹ºÈÕÆÚ¡¢¼Û¸ñ¡¢……)£¬"¶©µ¥±àºÅ"ΪÖ÷¼ü£¬"²úÆ·±àºÅ"ºÍÖ÷¼üÁÐûÓÐÖ±½ÓµÄ¹ØÏµ£¬¼´"²úÆ·±àºÅ"Áв»ÒÀÀµÓÚÖ÷¼üÁУ¬Ó¦É¾³ý¸ÃÁС£
µÚÈý·¶Ê½:ÔÚµÚ¶þ·¶Ê½µÄ»ù´¡Éϸü½øÒ»²ã,Ä¿±êÊÇÈ·±£Ã¿Áж¼ºÍÖ÷¼üÁÐÖ±½ÓÏà¹Ø,¶ø²»ÊǼä½ÓÏà¹Ø.
Èç¹ûÒ»¸ö¹ØÏµÂú×ãµÚ¶þ·¶Ê½,²¢ÇÒ³ýÁËÖ÷¼üÒÔÍâµÄÆäËüÁж¼²»ÒÀÀµÓÚÖ÷¼üÁÐ,ÔòÂú×ãµÚÈý·¶Ê½.
ΪÁËÀí½âµÚÈý·¶Ê½£¬ÐèÒª¸ù¾ÝArmstrong¹«ÀïÖ®Ò»¶¨Òå´«µÝÒÀÀµ¡£¼ÙÉèA¡¢BºÍCÊǹØÏµRµÄÈý¸öÊôÐÔ£¬Èç¹ûA-¡µBÇÒB-¡µC£¬Ôò´ÓÕâЩº¯ÊýÒÀÀµÖУ¬¿ÉÒԵóöA-¡µC£¬ÈçÉÏËùÊö£¬ÒÀÀµA-¡µCÊÇ´«µÝÒÀÀµ¡£
ÀýÈç:¶©µ¥±í(¶©µ¥±àºÅ£¬¶¨¹ºÈÕÆÚ£¬¹Ë¿Í±àºÅ£¬¹Ë¿ÍÐÕÃû£¬……)£¬³õ¿´¸Ã±íûÓÐÎÊÌ⣬Âú×ãµÚ¶þ·¶Ê½£¬Ã¿Áж¼ºÍÖ÷¼üÁÐ"¶©µ¥±àºÅ"Ïà¹Ø£¬ÔÙϸ¿´Äã»á·¢ÏÖ"¹Ë¿ÍÐÕÃû"ºÍ"¹Ë¿Í±àºÅ"Ïà¹Ø£¬"¹Ë¿Í±àºÅ"ºÍ"¶©µ¥±àºÅ"ÓÖÏà¹Ø£¬×îºó¾­¹ý´«µÝÒÀÀµ£¬"¹Ë¿ÍÐÕÃû"Ò²ºÍ"¶©µ¥±àºÅ"Ïà¹Ø¡£ÎªÁËÂú×ãµÚÈý·¶Ê½£¬Ó¦È¥µô"¹Ë¿ÍÐÕÃû"ÁУ¬·ÅÈë¿Í»§±íÖС£


Ïà¹ØÎĵµ£º

sql´æ´¢¹ý³Ì¶ÁÈ¡ÐÅÏ¢ÖÐÎÊÌâ

sql="select * from (select top 4 ID,SmallPic,NewsNameSi,EndDate,ContentSi,SortID from achi_news where ProductProperty=1 and IsOk=1 and HomeForcePage=1 and HomeEndTime>getDate() and isdate(HomeEndTime)=1 order by HomeorderNum asc  )a union all select * from (select top 4 ID,SmallPic,NewsNameS ......

sql ¸üÐÂÓï¾ä ¹ØÁªÁ½Õűí

sql Á½±í¹ØÁª ¸üР
update set from Óï¾ä¸ñʽ 
SybaseºÍSQL SERVER£ºUPDATE...SET...from...WHERE...µÄÓï·¨£¬Êµ¼ÊÉÏ´ÓÔ´±í»ñÈ¡¸üÐÂÊý¾Ý¡£ 
ÔÚ SQL ÖУº 
Update A SET A.dept =B.name 
from A LEFT JOIN B ON B.ID=A.dept_ID  ......

SQL ×óÓÒÁ¬½Ó

 ±¾ÎÄ×ªÔØÓÚ£ºhttp://www.javaeye.com/topic/185385
ѧϰÊý¾Ý¿â²éѯµÄʱºò¶Ô¶à±íÁ¬½Ó²éѯµÄÓÐЩ¸ÅÄ±È½ÏÄ£ºý¡£¶øÁ¬½Ó²éѯÊÇÔÚÊý¾Ý¿â²éѯ²Ù×÷µÄʱºò¿Ï¶¨ÒªÓõ½µÄ¡£¶ÔÓڴ˸ÅÄî
ÎÒÓÃͨË×һЩµÄÓïÑÔºÍÀý×ÓÀ´½øÐн²½â¡£Õâ¸öÀý×ÓÊÇÎÒ½²¿ÎµÄʱºò¾­³£²ÉÓõÄÀý×Ó¡£
Ê×ÏÈÎÒÃÇ×öÁ½ÕÅ±í£ºÔ±¹¤ÐÅÏ¢±íºÍ²¿ÃÅÐÅÏ¢±í£¬ÔÚ´Ë£¬±íµ ......

sqlÃæÊÔ

1.Ò»µÀSQLÓï¾äÃæÊÔÌ⣬¹ØÓÚgroup by
±íÄÚÈÝ£º
2005-05-09 ʤ
2005-05-09 ʤ
2005-05-09 ¸º
2005-05-09 ¸º
2005-05-10 ʤ
2005-05-10 ¸º
2005-05-10 ¸º
Èç¹ûÒªÉú³ÉÏÂÁнá¹û, ¸ÃÈçºÎдsqlÓï¾ä?
            ʤ ¸º
2005-05-09 2 2
2005-05-10 1 2
------------------------------- ......

ÐÂÊÖÈëÃÅ:SQL server2000°²×°Í¼½â

Microsoft SQL server2000ÓÉһϵÁÐÏ໥Э×÷µÄ×é¼þ¹¹³É¡£ÄÜÂú×ã×î´óµÄWEBÕ¾µãºÍÆóÒµÊý¾Ý´¦Àíϵͳ´æ´¢ºÍ·ÖÎöÊý¾ÝµÄÐèÒª¡£±¾ÎÄ´øÀ´µÄ¾ÍÊÇÔÚwindows»·¾³ÏÂSQL2000µÄ°²×°¹ý³Ì¡£
ϵͳÐèÇó
    ÕâÀïÒÔÆäËĺÏÒ»°æ±¾ÎªÀý£¬ÒÔϰ²×°¹ý³ÌͬÀí¡£Microsoft SQL Server 2000 ¿ÉÔÚÔËÐÐ Intel»ò¼æÈÝµÄ Pentium¡¢Pentium Pr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ