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

sqlµ¼ÈëµÄÎÊÌâ

ÎÒÔ­À´µÄsql2000Êý¾Ý¿âÉÏÓкܶàµÄÓû§,ÏÖÔÚÏë°ÑÕâЩÓû§¶¼µ¼³öµ½Ò»¸öеÄÊý¾Ý¿âÀӦ¸ÃÔõô×ö£¿Çë½Ì¸÷λ?!
sql2000ºÃÏñÖ»Äܵ¼Êý¾Ý¿â£¬²»ÖªµÀµÇÈëÓû§Ôõôµ¼Èë¡£Çë¸÷λ¸ø¸ö´ð°¸£¬Ð»Ð»£¡
»¹ÊÇÖØÐ½¨Á¢°É

Óû§²»Äܵ¼,ÔÚϵͳÊý¾Ý¿âµÄ,н¨°É

¹Ø¼üÊÇÄÇô¶àµÄÓû§£¬¶øÇÒ¶¼ÓÐÃÜÂ룬ÎÒ²»ÄܰÉÃÜÂë¶¼¸ÄÁ˰¡£¬Ã»°ì·¨Öؽ¨Å¶£¡

¸÷λ´ó¸ç£¬ÓÐʲôºÃ·½·¨°¡£¿

http://blog.csdn.net/fredrickhu/archive/2009/10/14/4669511.aspx

¿´¿´Õâ¸ö


Ïà¹ØÎÊ´ð£º

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

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

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......

ÇóÒ»¸ösqlÓï¾ä

A±í          B±í
WZID WZJG    WZID  CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......

ÇóÒ»¸ösqlÎĵÄд·¨

Ò»Õűítable×Ö¶ÎF1ºÍF2

F1    F2
1    a                               
2    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ