ͨ¹ý·ÖÎö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 Server Splitº¯Êý
--
Author:zc_0101
--
˵Ã÷£º
--
Ö§³Ö·Ö¸î·û¶à×Ö½Ú
--
ʹÓ÷½·¨
--
Select * from DBO.F_SQLSERVER_SPLIT('1203401230105045','0')
--
select * from DBO.F_SQLSERVER_SPLIT('abc1234a12348991234',' ......
**************************************
**** sql ²éѯ±¸Íü &nb ......
CASE ¿ÉÄÜÊÇ SQL Öб»ÎóÓÃ×î¶àµÄ¹Ø¼ü×ÖÖ®Ò»¡£ËäÈ»Äã¿ÉÄÜÒÔÇ°ÓùýÕâ¸ö¹Ø¼ü×ÖÀ´´´½¨×ֶΣ¬µ«ÊÇËü»¹¾ßÓиü¶àÓ÷¨¡£ÀýÈ磬Äã¿ÉÒÔÔÚ WHERE
×Ó¾äÖÐʹÓà CASE¡£
Ê×ÏÈÈÃÎÒÃÇ¿´Ò»Ï CASE µÄÓï·¨¡£ÔÚÒ»°ãµÄ SELECT ÖУ¬ÆäÓï·¨ÈçÏ£º
SELECT =
CASE
WHEN THEN
WHEN THEN
ELSE
......
Ò»¡¢×Ö·ûת»»º¯Êý
1¡¢ASCII()
·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ¡£ÔÚASCII£¨£©º¯ÊýÖУ¬´¿Êý×ÖµÄ×Ö·û´®¿É²»ÓÑ’À¨ÆðÀ´£¬µ«º¬ÆäËü×Ö·ûµÄ×Ö·û´®±ØÐëÓÑ’À¨ÆðÀ´Ê¹Ó㬷ñÔò»á³ö´í¡£
2¡¢CHAR()
½«ASCII Âëת»»Îª×Ö·û¡£Èç¹ûûÓÐÊäÈë0 ~ 255 Ö®¼äµÄASCII ÂëÖµ£¬CHAR£¨£© ·µ»ØNULL ¡£
3¡¢LOWE ......
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØϵÊý¾Ý¿âÖУ¬± ......