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

´ó¼Ò¶¼ÓÃʲô¹¤¾ß±àдSqlÓï¾ä°¡£¿

    ÓÐûÓÐÏósqlserver²éѯ·ÖÎöÆ÷ÒªºÍÆóÒµ¹ÜÀíÆ÷Ò»ÑùµÄ¹¤¾ß¡£»¹ÓÐʲôÆäËûµÄsql±à¼­¹¤¾ßÂð£¿
´ó¼Ò¶Ô ÏÖÔÚµÄsql±à¼­¹¤¾ß»¹ÓÐʲôҪÇóºÍ²»ÂúÒâµÄµØ·½Âð£¿Ëµ³öÀ´¿´¿´¡£
   
    ºÇºÇ£¬ÆäʵÊÇÏëд¸öÈí¹ã¸æ¡£¿ÉÊÇʵÔÚ²»»á´ë´Ç¡£
    ˵ʵ»°°É£¬Ð´Á˸ösql±à¼­¹¤¾ß¡£×ÔÎҸоõÁ¼ºÃ£¬»¶Ó­´ó¼Ò¸øµãÒâ¼û¡£ÎÒ¾¡Á¦È¥°Ñ´ó¼ÒµÄÏ뷨ʵÏÖ£¬Ð»Ð»£¡
    Èí¼þÃû³Æ£ºSqlEditPlugs
    ÏÂÔØµØÖ·£ºhttp://218.25.154.154:8081/Software/SqlEditPlugs.rar
    £¨·Ö˵ÓÐÏÞ£¬µÚÒ»¸öºÍ×îºóÒ»¸ö¸úÌûµÄÖ»Äܸ÷¸ø30·ÖÁË£©
=====================================================================================================
ÆÁ±ÎÊý¾Ý¿â¼äµÄ²îÒ죬ÒÔͳһµÄ½çÃæºÍ²Ù×÷·½Ê½À´¶ÔÊý¾Ý½øÐд¦Àí£¬½«³ÌÐòÔ±»òÊý¾Ý¹ÜÀíÔ±´Ó·±ËöµÄ²Ù×÷ģʽÖнâÍѳöÀ´£¬Ê¹Æä¸ü¼ÓרעµÄ½øÐÐSqlÓï¾äµÄ±àд¡£   
  ½«²éѯ·ÖÎöÆ÷ºÍÆóÒµ¹ÜÀíÆ÷¹¦Äܺ϶þΪһ£¬²¢ÈÚÈëÖÚ¶àʵÓù¦ÄÜ£¬²¢ÍêÃÀÖ§³Ö sqlserver¡¢oracle¡¢mysql¡¢access¡£ÊÇÄú±àдsqlÓï¾äºÍÊý¾Ý·ÖÎöµÄ¾ø¼Ñ°ïÊÖ¡£
  ¹ÙÍøµØÖ·£º
  http://www.i5iw.com 
  http://218.25.154.154:8081/
  QQȺ £º88725010
  E-Mail £ºl00f@163.com

  ¹¦ÄÜÁÐ±í£º
1¡¢´úÂë¸ßÁÁ£º¸ù¾Ý²Ù×÷Êý¾Ý¿âµÄ²»Í¬Çø·ÖÏàÓ¦¹Ø¼ü×Ö£¬²¢¸ßÁÁÏÔʾ
2¡¢×Ô¶¯Íê³É£ºÊäÈ벻ͬµÄ±íÃûµÈÐÅÏ¢£¬½«×Ô¶¯ÌáʾÏà¹ØµÄ×Ö¶ÎÐÅÏ¢µÈ¡£
3¡¢ÖÇÄÜÌáʾ£ºÊäÈëÏàÓ¦¹Ø¼ü×Ö½«³öÏÖÀàËÆVSÖÐÒ»ÑùµÄ˵Ã÷Ìáʾ¡£
4¡¢¿ç¿â²Ù×÷£º¿Éͬʱ¿ç¶à¸öÊý¾Ý¿â¼ä²Ù×÷£¬»¥²»Ó°Ïì¡£ËæÊ±Çл»£¬ËæÊ±ÔËÐС


Ïà¹ØÎÊ´ð£º

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ