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

³ýÁ˲éѯ·ÖÎöÆ÷£¬»¹ÓÐʲôSql±à¼­Æ÷¿ÉÓã¿

    ²éѯ·ÖÎöÆ÷ÒªºÍÆóÒµ¹ÜÀíÆ÷Ò»ÆðÓòŹýñ«¡£»¹ÓÐʲôÆäËûµÄsql±à¼­¹¤¾ßÂð£¿
´ó¼Ò¶Ô ÏÖÔÚµÄsql±à¼­¹¤¾ß»¹ÓÐʲôҪÇóºÍ²»ÂúÒâµÄµØ·½Âð£¿Ëµ³öÀ´¿´¿´¡£
   
    ºÇºÇ£¬ÆäʵÊÇÏëд¸öÈí¹ã¸æ¡£¿ÉÊÇʵÔÚ²»»á´ë´Ç¡£
    ˵ʵ»°°É£¬Ð´Á˸ösql±à¼­¹¤¾ß¡£×ÔÎҸоõÁ¼ºÃ£¬»¶Ó­´ó¼Ò¸øµãÒâ¼û¡£ÎÒ¾¡Á¦È¥°Ñ´ó¼ÒµÄÏ뷨ʵÏÖ£¬Ð»Ð»£¡
    Èí¼þÃû³Æ£ºSqlEditPlugs
    ÏÂÔØµØÖ·£ºhttp://218.25.154.154:8081/Software/SqlEditPlugs.rar
   
=====================================================================================================
ÆÁ±ÎÊý¾Ý¿â¼äµÄ²îÒ죬ÒÔͳһµÄ½çÃæºÍ²Ù×÷·½Ê½À´¶ÔÊý¾Ý½øÐд¦Àí£¬½«³ÌÐòÔ±»òÊý¾Ý¹ÜÀíÔ±´Ó·±ËöµÄ²Ù×÷ģʽÖнâÍѳöÀ´£¬Ê¹Æä¸ü¼ÓרעµÄ½øÐÐ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¡¢¿ç¿â²Ù×÷£º¿Éͬʱ¿ç¶à¸öÊý¾Ý¿â¼ä²Ù×÷£¬»¥²»Ó°Ïì¡£ËæÊ±Çл»£¬ËæÊ±ÔËÐС£
5¡¢ËæÒâÔËÐУºÔËÐÐÑ¡ÔñµÄ´úÂë¡¢ÔËÐжà¸öSql²Ù×÷´úÂë¡£Èç¹û


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ