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

sql»ù´¡ÖªÊ¶

SQLÓïÑÔÓÉÃüÁî¡¢×Ӿ䡢ÔËËãºÍ¼¯ºÏº¯ÊýµÈ¹¹³É¡£ÔÚSQLÖУ¬Êý¾Ý¶¨ÒåÓïÑÔDDL£¨ÓÃÀ´½¨Á¢¼°¶¨ÒåÊý¾Ý±í¡¢×Ö¶ÎÒÔ¼°Ë÷ÒýµÈÊý¾Ý¿â½á¹¹£©°üº¬µÄÃüÁîÓÐCREATE¡¢DROP¡¢ALTER£»Êý¾Ý²Ù×ÝÓïÑÔDML£¨ÓÃÀ´ÌṩÊý¾ÝµÄ²éѯ¡¢ÅÅÐòÒÔ¼°É¸Ñ¡Êý¾ÝµÈ¹¦ÄÜ£©°üº¬µÄÃüÁîÓÐSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡£
Ò»¡¢SQLÓï¾ä
£¨1£©Select ²éѯÓï¾ä
Óï·¨£ºSELECT [ALL|DISTINCT] <Ä¿±êÁбí´ïʽ> [AS ÁÐÃû]
[,<Ä¿±êÁбí´ïʽ> [AS ÁÐÃû] ...] from <±íÃû> [£¬<±íÃû>…]
[WHERE <Ìõ¼þ±í´ïʽ> [AND|OR <Ìõ¼þ±í´ïʽ>...]
[GROUP BY ÁÐÃû [HAVING <Ìõ¼þ±í´ïʽ>>
[ORDER BY ÁÐÃû [ASC | DESC>
½âÊÍ£º[ALL|DISTINCT]   ALL£ºÈ«²¿£» DISTINCT£º²»°üÀ¨Öظ´ÐÐ
<Ä¿±êÁбí´ïʽ> ¶Ô×ֶοÉʹÓÃAVG¡¢COUNT¡¢SUM¡¢MIN¡¢MAX¡¢ÔËËã·ûµÈ
<Ìõ¼þ±í´ïʽ>
²éѯÌõ¼þ ν´Ê
±È½Ï =¡¢>,<,>=,<=,!=,<>,
È·¶¨·¶Î§ BETWEEN AND¡¢NOT BETWEEN AND
È·¶¨¼¯ºÏ IN¡¢NOT IN
×Ö·ûÆ¥Åä LIKE£¨“%”Æ¥ÅäÈκγ¤¶È£¬“_”Æ¥ÅäÒ»¸ö×Ö·û£©¡¢NOT LIKE
¿ÕÖµ IS NULL¡¢IS NOT NULL
×Ó²éѯ ANY¡¢ALL¡¢EXISTS
¼¯ºÏ²éѯ UNION£¨²¢£©¡¢INTERSECT£¨½»£©¡¢MINUS£¨²î£©
¶àÖØÌõ¼þ AND¡¢OR¡¢NOT
<GROUP BY ÁÐÃû> ¶Ô²éѯ½á¹û·Ö×é
[HAVING <Ìõ¼þ±í´ïʽ>] ·Ö×éɸѡÌõ¼þ
[ORDER BY ÁÐÃû [ASC | DESC> ¶Ô²éѯ½á¹ûÅÅÐò£»ASC£ºÉýÐò DESC£º½µÐò
Àý1£º select student.sno as ѧºÅ, student.name as ÐÕÃû, course as ¿Î³ÌÃû, score as ³É¼¨ from score,student where student.sid=score.sid and score.sid=:sid
Àý2£ºselect student.sno as ѧºÅ, student.name as ÐÕÃû,AVG(score) as ƽ¾ù·Ö from score,student where student.sid=score.sid and student.class=:class and (term=5 or term=6) group by student.sno, student.name having count(*)>0 order by ƽ¾ù·Ö DESC
Àý3£ºselect * from score where sid like '9634'
Àý4£ºselect * from student where class in (select class from student where name='³ÂСС')
£¨2£©INSERT²åÈëÓï¾ä
Óï·¨£ºINSERT INTO <±íÃû> [£¨<×Ö¶ÎÃû1> [,<×Ö¶ÎÃû2>, ...])] VALUES (<³£Á¿1> [,<³£Á¿2>, ...])
Óï·¨£ºINSERT INTO <±íÃû> [£¨<×Ö¶ÎÃû1> [,<×Ö¶ÎÃû2>, ...])] ×Ó²éѯ
Àý×Ó£ºINSERT INTO ½èÊé±í£¨


Ïà¹ØÎĵµ£º

ORACLE SQLÖ´Ðв½Öè

 ORACLE sql µÄ´¦Àí¹ý³Ì´óÖÂÈçÏ£º
 1.ÔËÓÃHASHËã·¨£¬µÃµ½Ò»¸öHASHÖµ£¬Õâ¸öÖµ¿ÉÒÔͨ¹ýV$SQLAREA.HASH_VALUE ²é¿´
 2.µ½shared pool ÖÐµÄ library cache ÖвéÕÒÊÇ·ñÓÐÏàͬµÄHASHÖµ£¬Èç¹û´æÔÚ£¬ÔòÎÞÐèÓ²½âÎö£¬½øÐÐÈí½âÎö
 3.Èç¹ûshared pool²»´æÔÚ´ËHASHÖµ£¬Ôò½øÐÐÓï·¨¼ì²é£¬²é¿´ÊÇ·ñÓÐÓï·¨´íÎó
&nbs ......

ORACLE PL/SQL ´æ´¢¹ý³Ì½Ì³Ì


(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà  ÕâÑù£º     
SELECT tmp#_seq.NEXTVAL
        INTO id_temp
        from DUAL;  È»ºó¿ÉÒ ......

ASP.NETÔ¶³Ì±¸·Ý»Ö¸´SQL ServerÊý¾Ý¿â

///<summary>
      ///±¸·ÝÊý¾Ý¿âµ½±¾µØ´ÅÅÌ
      ///</summary>
    public bool BackUp(string BackUpFile)
    {
        try
&nbs ......

SQL Server 2005 ²»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ½â¾ö·½·¨

¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈϰ²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƪ»úÆ÷·­ÒëµÄÎÄÕ£¬ÊµÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......

SQL ÖÐROLLUP Ó÷¨

ROLLUP ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÀàËÆÓÚ CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯¡£ ÏÂÃæÊÇ CUBE ºÍ ROLLUP Ö®¼äµÄ¾ßÌåÇø±ð£º CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£ ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£ ROLLUP Óŵ㣺 £¨£±£©ROLLUP ·µ»Øµ¥¸ö½á¹û¼¯£¬¶ø COMPUTE BY ·µ»Ø¶à¸ö½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ