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

SQL¸ß¼¶²éѯ

ÏÖÔÚÒª×öÒ»¸ö¸ß¼¶²éѯ¹¦ÄÜ ÒòΪ²éѯµÄ±íºÜ.ÿ¸ö±íµÄij¸öÖµ¶¼ÓпÉÄÜÊDzéѯÌõ¼þ
ÎÒ¾Í×öÁËÒ»¸öÏÂÀ­¿òÁª¶¯À´ÏÔʾ±íºÍÁÐ
ÏÖÔÚÖ÷±íÊÇUserInfo ÒÔÏÂµÄ´Ó±í¶¼ÊÇÒ»¶Ô¶àµÄ¹ØÏµ Ò²¾ÍÊÇÿ¸ö±íijһ¸öÓû§¶¼ÓÐ1-2ÌõµÄ¼Ç¼(×î¶à2Ìõ)

ÐèÒª²éѯ15Õűí Èç¹ûÿ¸ö±íµÄÿ¸öÈ˶¼ÊÇÒ»¶ÔÒ»µÄ»°.300¸öÓû§ left joinºó¾ÍÊÇ×î¶à300ÈË
¶øÏÖÔÚ ÎÒÈ«²¿´®ÆðÀ´´óÔ¼¾ÍÓÐ30ÍòÌõ¼Ç¼

ÏÈ˵һÏÂÎÒµÄ×ö·¨°É

×ó±ßÊÇÑ¡Ïî Óû§Ñ¡Ôñ±í ÔÚÑ¡ÔñÁÐ ÔÚÊäÈëÌõ¼þ (µÈÓÚ ´óÓÚ Ð¡ÓÚ) ×îºó²éѯֵÊäÈë²éѯֵ
ÎÒ°ÑÕâЩÌõ¼þÓÃÒ»¸öÁбíÏÔʾ³öÀ´ È»ºóÓû§¼ÌÐøÌí¼Ó Ö±µ½Óû§µã²éѯµÄʱºòÎÒÔÚ°ÑÌõ¼þÕûºÏÆðÀ´
¿ÉÊÇÏÖÔÚ³öÏÖÁ˵ÄÎÊÌâ¾ÍÊÇÓР »ò(or) Õâ¸ö¹ØÏµ ÎҵIJéѯÌõ¼þÊÇ and ...and ...and ÏÖÔÚ¶à³öÒ»¸ö»òÕâÑùµÄÌõ¼þ Ò²¾ÍÊÇ˵ÎҵøøËû ºÍËûÇ°ÃæµÄ²éѯÌõ¼þ ´ò¸öÀ¨ºÅ.Òª²»È»¾Í°×²éÁË µ«²»ÎÒÖªµÀÔõô¸øËû¼ÓÀ¨ºÅ

¸÷λ´ó¸çÄܰ´ÎÒµÄÒªÇó¸øÎÒÒ»µã˼·Âð?ÎÒ²»ÖªµÀ¸ÃÔõô×öÁË
orµÄǰһ¸öÌõ¼þ֮ǰ¼Ó(
orµÄºóÒ»¸öÌõ¼þÖ®ºó¼Ó)


ÄãµÄ±íËÆºõÉè¼ÆµÃÓÐÎÊÌâ

ÏȹýÂËÔÙ¼¶Áª£¬°´Ìõ¼þ¾¡Á¿ÏÈɸѡ£¬²»Òª¼¶ÁªºóÔÙ²éѯ¡£

LZ°ÑÎÊÌâԽ˵Խ¶ñÐÄ

ºÃ²»Çå³þ°¡

û¿´¶®

·Ö×é
±ÈÈç˵Ìõ¼þ a=1 or (b=1 and c=1)
ÄÇô¾ÍÊÇa=1Ϊһ¸ö×é g1
b=1 and c=1 Ϊg2

¼Ç¼g1ºÍg2Ö®¼äµÄ¹ØÏµÎªor  g1°üº¬µÄSqlÓï¾äΪa=1  g2Ϊb=1 and c=1
È»ºó¸ù¾ÝÕâ¸ö¹æÔò×é×°whereÓï¾ä

×鵱ȻҲ¿ÉÒÔ°üº¬×飬ÕâÑù¾Í¿ÉÒÔÎÞÏÞÖÆµÄ·Ö×éÏÂÈ¥
×é¿ÉÒÔÓÐ×Ó×飬ÕâÑù¾Í¿ÉÒÔ´òµ½×é×°SqlµÄÄ¿µÄÁË¡£
Ò³Ãæ¿ØÖƱȽϸ´ÔÓ



ÐèÒª´óÁ¿µÄjsÀ´Ö§³Ö¸´Ô


Ïà¹ØÎÊ´ð£º

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

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

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

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

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

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

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

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

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

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ