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

SQL Server CHARINDEXº¯ÊýºÍPATINDEXº¯ÊýÏê½â

¼ÙÈçÄãд¹ýºÜ¶à³ÌÐò£¬Äã¿ÉÄÜż¶û»áÅöµ½ÒªÈ·¶¨×Ö·û»ò×Ö·û´Ü´®·ñ°üº¬ÔÚÒ»¶ÎÎÄ×ÖÖУ¬ÔÚÕâÆªÎÄÕÂÖУ¬ÎÒ½«ÌÖÂÛʹÓÃCHARINDEXºÍPATINDEXº¯ÊýÀ´ËÑË÷ÎÄ×ÖÁкÍ×Ö·û´®¡£ÎÒ½«¸æËßÄãÕâÁ½¸öº¯ÊýÊÇÈçºÎÔËתµÄ£¬½âÊÍËûÃǵÄÇø±ð¡£Í¬Ê±ÌṩһЩÀý×Ó£¬Í¨¹ýÕâЩÀý×Ó£¬Äã¿ÉÒÔ¿ÉÒÔ¿¼ÂÇʹÓÃÕâÁ½¸öº¯ÊýÀ´½â¾öºÜ¶à²»Í¬µÄ×Ö·ûËÑË÷µÄÎÊÌâ¡£
¡¡¡¡CHARINDEXºÍPATINDEXº¯Êý³£³£ÓÃÀ´ÔÚÒ»¶Î×Ö·ûÖÐËÑË÷×Ö·û»òÕß×Ö·û´®¡£Èç¹û±»ËÑË÷µÄ×Ö·ûÖаüº¬ÓÐÒªËÑË÷µÄ×Ö·û£¬ÄÇôÕâÁ½¸öº¯Êý·µ»ØÒ»¸ö·ÇÁãµÄÕûÊý£¬Õâ¸öÕûÊýÊÇÒªËÑË÷µÄ×Ö·ûÔÚ±»ËÑË÷µÄ×Ö·ûÖеĿªÊ¼Î»Êý¡£PATINDEXº¯ÊýÖ§³ÖʹÓÃͨÅä·ûÀ´½øÐÐËÑË÷£¬È»¶øCHARINDEX²»Ö§³ÖͨÅå·û¡£½ÓÏÂÀ´£¬ÎÒÃÇÖð¸ö·ÖÎöÕâÁ½¸öº¯Êý¡£
ÈçºÎʹÓÃCHARINDEXº¯Êý¡£
¡¡¡¡CHARINDEXº¯Êý·µ»Ø×Ö·û»òÕß×Ö·û´®ÔÚÁíÒ»¸ö×Ö·û´®ÖÐµÄÆðʼλÖá£
¡¡¡¡CHARINDEXº¯Êýµ÷Ó÷½·¨ÈçÏ£º
¡¡¡¡CHARINDEX ( expression1 , expression2 [ , start_location ] )
¡¡¡¡Expression1ÊÇÒªµ½expression2ÖÐѰÕÒµÄ×Ö·ûÖУ¬start_locationÊÇCHARINDEXº¯Êý¿ªÊ¼ÔÚexpression2ÖÐÕÒexpression1µÄλÖá£
¡¡¡¡CHARINDEXº¯Êý·µ»ØÒ»¸öÕûÊý£¬·µ»ØµÄÕûÊýÊÇÒªÕÒµÄ×Ö·û´®ÔÚ±»ÕÒµÄ×Ö·û´®ÖеÄλÖ᣼ÙÈçCHARINDEXûÓÐÕÒµ½ÒªÕÒµÄ×Ö·û´®£¬ÄÇôº¯ÊýÕûÊý“0”¡£
¡¡¡¡ÈÃÎÒÃÇ¿´¿´ÏÂÃæµÄº¯ÊýÃüÁîÖ´ÐеĽá¹û£º
¡¡¡¡CHARINDEX(’SQL’, ’Microsoft SQL Server’)
¡¡¡¡Õâ¸öº¯ÊýÃüÁ·µ»ØÔÚ“Microsoft SQL Server”ÖГSQL”µÄÆðʼλÖã¬ÔÚÕâ¸öÀý×ÓÖУ¬CHARINDEXº¯Êý½«·µ»Ø“S”ÔÚ“Microsoft SQL Server”ÖеÄλÖÃ11¡£
½ÓÏÂÀ´£¬ÎÒÃÇ¿´Õâ¸öCHARINDEXÃüÁ
¡¡¡¡CHARINDEX(’7.0’, ’Microsoft SQL Server 2000’)
¡¡¡¡ÔÚÕâ¸öÀý×ÓÖУ¬CHARINDEX·µ»ØÁ㣬ÒòΪ×Ö·û´®“7.0” ²»ÄÜÔÚ“Microsoft SQL Server”Öб»ÕÒµ½¡£½ÓÏÂÀ´Í¨¹ýÁ½¸öÀý×ÓÀ´¿´¿´ÈçºÎʹÓÃCHARINDEXº¯ÊýÀ´½â¾öʵ¼ÊµÄT-SQLÎÊÌâ¡£
¡¡¡¡µÚÒ»¸öÀý×Ó£¬¼ÙÉèÄãÒªÏÔʾNorthwindÊý¾Ý¿âCustomer±íǰ5ÐÐÁªÏµÈËÁеÄLast Name¡£ÕâÊÇǰ5ÐÐÊý¾Ý
           ContactName
           ------------------------------ 
           Maria Anders
   &nbs


Ïà¹ØÎĵµ£º

SQL ServerÊý¾Ý¿â¸÷¶ÔÏóµÄ×î´óÈÝÁ¿ËµÃ÷

ϱí˵Ã÷ÔÚ Microsoft SQL Server Êý¾Ý¿âÖж¨ÒåµÄ£¬»òÔÚ Transact-SQL
Óï¾äÖÐÒýÓõĸ÷ÖÖ¶ÔÏóµÄ×î´óÖµ£¨ÊýÁ¿»ò´óС£©¡£ÏÂ±í²»°üº¬ Microsoft® SQL Server 2000™ Windows® CE °æ¡£
 
×î´óÖµ£¨ÊýÁ¿»ò´óС£©
¶ÔÏó
SQL Server 7.0
SQL Server 2000
Åú´¦Àí´óС
65,536 * ÍøÂçÊý¾Ý°ü´óС1
65,536 * Í ......

SQL SERVERʹÓÃÁ´½Ó·þÎñÆ÷

1¡¢ÔÚÁíһ̨»úÆ÷ÉϽ¨Á¢¶ÀÁ¢µÄÊý¾Ý¿â·þÎñÆ÷£¬×÷ΪÁ´½ÓÄ¿±ê
2¡¢±¾µØÊý¾Ý¿â·þÎñÆ÷ÉÏÌí¼Ó“Á´½Ó·þÎñÆ÷”£º
Ãû×Ö£ºËæ±ãȡһ¸öÃû×Ö
·þÎñÆ÷ÀàÐÍ£ºÑ¡ÔñÊý¾ÝÔ´£ºMicrosoft OLE DB Provider for SQL Server
Êý¾ÝÔ´£ºÐ´±ðÃû£¨ÔÚ¿Í»§¶ËÍøÂçʵÓù¤¾ßÖÐÉèÖã©
Ñ¡ÖÐRPCºÍRPCÊä³ö ......

SQLÓï¾äÓÅ»¯·½·¨

ÎÒÃÇÒª×öµ½²»µ«»áдSQL£¬»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQLÓï¾ä¡£ 
¡¡¡¡
¡¡¡¡£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º 
¡¡¡¡
¡¡¡¡OracleµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ ......

MySQL Ñϸñģʽ sql_mode

ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
  `id` int(11) default NULL,
  `num` int(11) unsigned default NULL
) ENGINE=InnoDB DE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ