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

ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL

ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL(×ܽá)
×ö DBA¿ì7ÄêÁË£¬Öмä¸ÐÎòºÜ¶à¡£ÔÚDBAµÄÈÕ³£¹¤×÷ÖУ¬µ÷Õû¸ö±ðÐÔÄܽϲîµÄSQLÓï¾äʱһÏÓÐÌôÕ½ÐԵŤ×÷¡£ÆäÖеĹؼüÔÚÓÚÈçºÎµÃµ½SQLÓï¾äµÄÖ´Ðмƻ®ºÍÈçºÎ´ÓSQLÓï¾äµÄÖ´Ðмƻ®Öз¢ÏÖÎÊÌâ¡£×ÜÊÇÏ뽫ÈÕ³£¾­ÑéµÄµãµãµÎµÎ×ܽáһϣ¬µ«ÊÇÖ±µ½×î½ü²Å϶¨¾öÐÄ£¬×ܹ²»¨ÁË3¸öÖÜĩʱ¼ä£¬²Å½«ÆäÕûÀí³É²á£¬±ãÓÚ×Ô¼ºÈÕ³£¹¤×÷¡£²»ºÃÒâ˼¶ÀÏí£¬ËùÒÔ½«ÆäÌù³öÀ´¡£
µÚÒ»Õ¡¢µÚ2Õ ²¢²»ÊǺÜÖØÒª£¬ÊÇ×Ô¼ºµÄһЩÏë·¨£¬¹ØÓÚÈçºÎ×öÒ»¸öÎȶ¨¡¢¸ßЧµÄÓ¦ÓÃϵͳµÄһЩÏë·¨¡£
µÚÈýÕÂÒÔºó¶¼ÊDZȽÏÖØÒªµÄ¡£
¸½Â¼µÄÄÚÈÝÒ²ÊDZȽÏÖØÒªµÄ¡£ÎÒ³£Óøò¿·ÖµÄÄÚÈÝ¡£
                                                ǰÑÔ
      ±¾ÎĵµÖ÷Òª½éÉÜÓëSQLµ÷ÕûÓйصÄÄÚÈÝ£¬ÄÚÈÝÉæ¼°¶à¸ö·½Ã棺SQLÓï¾äÖ´ÐеĹý³Ì¡¢ORACLEÓÅ»¯Æ÷£¬±íÖ®¼äµÄ¹ØÁª£¬ÈçºÎµÃµ½SQLÖ´Ðмƻ®£¬ÈçºÎ·ÖÎöÖ´Ðмƻ®µÈÄÚÈÝ£¬´Ó¶øÓÉdzµ½ÉîµÄ·½Ê½Á˽âSQLÓÅ»¯µÄ¹ý³Ì£¬Ê¹´ó¼ÒÖð²½²½ÈëSQLµ÷ÕûÖ®ÃÅ£¬È»ºóÄ㽫·¢ÏÖ……¡£
  Ŀ¼
µÚ1Õ ÐÔÄܵ÷Õû×ÛÊö
µÚ2Õ ÓÐЧµÄÓ¦ÓÃÉè¼Æ
µÚ3Õ  SQLÓï¾ä´¦ÀíµÄ¹ý³Ì
µÚ4Õ ORACLEµÄÓÅ»¯Æ÷
µÚ5Õ ORACLEµÄÖ´Ðмƻ®
        ·ÃÎÊ·¾¶(·½·¨) -- access path
        ±íÖ®¼äµÄÁ¬½Ó
        ÈçºÎ²úÉúÖ´Ðмƻ®
        ÈçºÎ·ÖÎöÖ´Ðмƻ®
        ÈçºÎ¸ÉÔ¤Ö´Ðмƻ® - - ʹÓÃhintsÌáʾ
        ¾ßÌå°¸Àý·ÖÎö
µÚ6Õ ÆäËü×¢ÒâÊÂÏî
¸½Â¼
µÚ1Õ ÐÔÄܵ÷Õû×ÛÊö
   
    OracleÊý¾Ý¿âÊǸ߶ȿɵ÷µÄÊý¾Ý¿â²úÆ·¡£±¾ÕÂÃèÊöµ÷ÕûµÄ¹ý³ÌºÍÄÇЩÈËÔ±Ó¦ÓëOracle·þÎñÆ÷µÄµ÷ÕûÓйأ¬ÒÔ¼°Óëµ÷ÕûÏà¹ØÁªµÄ²Ù×÷ϵͳӲ¼þºÍÈí¼þ¡£±¾Õ°üÀ¨ÒÔÏ·½Ãæ:
l        Ë­À´µ÷Õûϵͳ?
l        ʲôʱºòµ÷Õû?
l     &nbs


Ïà¹ØÎĵµ£º

sql ±¸Íü

**************************************
****     sql  ²éѯ±¸Íü                                   &nb ......

SQL¾ÛºÏº¯


SQL¾ÛºÏº¯
±êÇ©£ºsql¾ÛºÏº¯Êý ÔÓ̸ 
 
¾ÛºÏº¯Êý£º
1.AVG ·µ»Ø×éÖÐµÄÆ½¾ùÖµ£¬¿ÕÖµ½«±»ºöÂÔ¡£
ÀýÈ磺use  northwind   // ²Ù×÷northwindÊý¾Ý¿â
   Go
   Select  avg (unitprice)   //´Ó±íÖÐÑ¡ÔñÇóunitpriceµÄƽ¾ùÖµ
    & ......

ÔÚCMDϲÙ×÷SQL SERVERÊý¾Ý¿â


MYSQL¿ÉÒÔÔÚ¿ØÖÆÌ¨Ï½øÐвÙ×÷£¬ÀûÓÃÃüÁî
SQL´úÂë
mysql -h localhost -u root -p123456  
¾Í¿ÉÒԵǽMYSQLµÄ¿ØÖÆÌ¨¡£
sql serverÒ²ÌṩÁË¿ØÖÆÌ¨ÏµIJÙ×÷¹¦ÄÜ¡£
ÔÚSQL SERVERµÄ binnĿ¼Ï£¬ÌṩÁËosql.exeÓëisql.exeÕâÁ½¸öÎļþ¡£
ÕâÁ½¸ö³ÌÐò¶¼ÌṩÁË·ÃÎÊSQL SERVERµÄ¹¦ÄÜ£¬ÕâÁ ......

SQL×Ö·û´®´¦Àíº¯Êý»ã×Ü

Ò»¡¢×Ö·ûת»»º¯Êý
1¡¢ASCII()
·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ¡£ÔÚASCII£¨£©º¯ÊýÖУ¬´¿Êý×ÖµÄ×Ö·û´®¿É²»ÓÑ’À¨ÆðÀ´£¬µ«º¬ÆäËü×Ö·ûµÄ×Ö·û´®±ØÐëÓÑ’À¨ÆðÀ´Ê¹Ó㬷ñÔò»á³ö´í¡£
2¡¢CHAR()
½«ASCII Âëת»»Îª×Ö·û¡£Èç¹ûûÓÐÊäÈë0 ~ 255 Ö®¼äµÄASCII ÂëÖµ£¬CHAR£¨£© ·µ»ØNULL ¡£
3¡¢LOWE ......

SQL Server CONVERT() º¯Êý

Ô­Îijö´¦£ºhttp://www.dingos.cn/index.php?topic=1874.0
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊǰÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_conve ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ