sql server charindexºÍpatindexÏê½â
¼ÙÈçÄãд¹ýºÜ¶à³ÌÐò£¬Äã¿ÉÄÜż¶û»áÅöµ½ÒªÈ·¶¨×Ö·û»ò×Ö·û´Ü´®·ñ°üº¬ÔÚÒ»¶ÎÎÄ×ÖÖУ¬ÔÚÕâÆªÎÄÕÂÖУ¬ÎÒ½«ÌÖÂÛʹÓÃCHARINDEXºÍPATINDEXº¯ÊýÀ´ËÑË÷ÎÄ×ÖÁкÍ×Ö·û´®¡£ÎÒ½«¸æËßÄãÕâÁ½¸öº¯ÊýÊÇÈçºÎÔËתµÄ£¬½âÊÍËûÃǵÄÇø±ð¡£Í¬Ê±ÌṩһЩÀý×Ó£¬Í¨¹ýÕâЩÀý×Ó£¬Äã¿ÉÒÔ¿ÉÒÔ¿¼ÂÇʹÓÃÕâÁ½¸öº¯ÊýÀ´½â¾öºÜ¶à²»Í¬µÄ×Ö·ûËÑË÷µÄÎÊÌâ¡£
CHARINDEXºÍPATINDEXº¯Êý³£³£ÓÃÀ´ÔÚÒ»¶Î×Ö·ûÖÐËÑË÷×Ö·û»òÕß×Ö·û´®¡£Èç¹û±»ËÑË÷µÄ×Ö·ûÖаüº¬ÓÐÒªËÑË÷µÄ×Ö·û£¬ÄÇôÕâÁ½¸öº¯Êý·µ»ØÒ»¸ö·ÇÁãµÄÕûÊý£¬Õâ¸öÕûÊýÊÇÒªËÑË÷µÄ×Ö·ûÔÚ±»ËÑË÷µÄ×Ö·ûÖеĿªÊ¼Î»Êý¡£PATINDEXº¯ÊýÖ§³ÖʹÓÃͨÅä·ûÀ´½øÐÐËÑË÷£¬È»¶øCHARINDEX²»Ö§³ÖͨÅå·û¡£½ÓÏÂÀ´£¬ÎÒÃÇÖð¸ö·ÖÎöÕâÁ½¸öº¯Êý¡£ ÄúËùä¯ÀÀµÄÎÄÕÂÀ´×Ô86oo.com
ÈçºÎʹÓÃCHARINDEXº¯Êý
www.86oo.com
CHARINDEXº¯Êý·µ»Ø×Ö·û»òÕß×Ö·û´®ÔÚÁíÒ»¸ö×Ö·û´®ÖÐµÄÆðʼλÖá£CHARINDEXº¯Êýµ÷Ó÷½·¨ÈçÏ£º
www.86oo.com
CHARINDEX ( expression1 , expression2 [ , start_location ] )
86oo.comÌṩ¸÷Àà½Ì³Ì
Expression1ÊÇÒªµ½expression2ÖÐѰÕÒµÄ×Ö·ûÖУ¬start_locationÊÇCHARINDEXº¯Êý¿ªÊ¼ÔÚexpression2ÖÐÕÒexpression1µÄλÖá£
86oo¾«²Ê½Ì³Ì
CHARINDEXº¯Êý·µ»ØÒ»¸öÕûÊý£¬·µ»ØµÄÕûÊýÊÇÒªÕÒµÄ×Ö·û´®ÔÚ±»ÕÒµÄ×Ö·û´®ÖеÄλÖ᣼ÙÈçCHARINDEXûÓÐÕÒµ½ÒªÕÒµÄ×Ö·û´®£¬ÄÇôº¯ÊýÕûÊý“0”¡£ÈÃÎÒÃÇ¿´¿´ÏÂÃæµÄº¯ÊýÃüÁîÖ´ÐеĽá¹û£º 86oo.com»¶ÓÄã
CHARINDEX('SQL', 'Microsoft SQL Server') www.86oo.com
Õâ¸öº¯ÊýÃüÁ·µ»ØÔÚ“Microsoft SQL Server”ÖГSQL”µÄÆðʼλÖã¬ÔÚÕâ¸öÀý×ÓÖУ¬CHARINDEXº¯Êý½«·µ»Ø“S”ÔÚ“Microsoft SQL Server”ÖеÄλÖÃ11¡£
½ÓÏÂÀ´£¬ÎÒÃÇ¿´Õâ¸öCHARINDEXÃüÁ 86oo.com»¶ÓÄã
CHARINDEX('7.0', 'Microsoft SQL Server 2000') 86oo¾«²Ê½Ì³Ì
ÔÚÕâ¸öÀý×ÓÖУ¬CHARINDEX·µ»ØÁ㣬ÒòΪ×Ö·û´®“7.0” ²»ÄÜÔÚ“Microsoft SQL Server”Öб»ÕÒµ½¡£½ÓÏÂÀ´Í¨¹ýÁ½¸öÀý×ÓÀ´¿´¿´ÈçºÎ
Ïà¹ØÎĵµ£º
Èç¹ûÄã¾³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......
inner join,full outer join,left join,right jion
ÄÚ²¿Á¬½Ó inner join Á½±í¶¼Âú×ãµÄ×éºÏ
full outer È«Á¬ Á½±íÏàͬµÄ×éºÏÔÚÒ»Æð£¬A±íÓУ¬B±íûÓеÄÊý¾Ý£¨ÏÔʾΪnull£©,ͬÑùB±íÓÐ
A±íûÓеÄÏÔʾΪ(null)
A±í left join B±í ×óÁ¬,ÒÔA±íΪ»ù´¡£¬A±íµÄÈ«²¿Êý¾Ý£¬B±íÓеÄ×éºÏ¡£Ã»ÓеÄΪnull
A±í right join B±í ÓÒÁ ......
±àдһ¸ö´¢´æ¹ý³Ìusp_GetSortedShippers£¬Ëü½ÓÊÕNorthwindÊý¾Ý¿âÖÐShippers±íµÄÒ»¸öÁÐÃû³Æ×÷ΪÆäÖÐÒ»¸öÊäÈ루@colname£©£¬²¢´Ó¸Ã±í·µ»Ø°´ÊäÈëµÄÁÐÃûÅÅÐòµÄÐС£ÁíÒ»¸öÊäÈ루@sortdir£©±íʾÅÅÐòµÄ·½Ïò,‘A’±íʾ°´Éý˳ÅÅÐò,‘D’±íʾ°´½µÐòÅÅÐò¡£±àд¸Ã´æ´¢¹ý³ÌʱҪעÒâËüµÄÐÔÄÜ£¬¼´£¬¾¡¿ÉÄܵÄʹÓÃË÷Òý£¨ ......
sql×¢Èë·ÀÖ¹µÄ·½Ê½£º
1.×î¸ù±¾µÄ°ì·¨¾ÍÊÇʹÓÃÔ¤±àÒëµÄ·½Ê½½øÐÐÊý¾Ý¿â²Ù×÷¡£¼´Ê±Ê¹Ó㿵ķ½Ê½¡£
2.ʹÓùýÂËÀà¡£
·ÀÖ¹¿çÕ¾½Å±¾µÄ·½Ê½£º
1.ÔÚÊý¾Ý¼Èë½×¶Î½øÐйýÂË£¬µ«ÊÇÕâÖÖ·½Ê½»áÊǶªÊ§Ò»Ð©Êý¾Ý¡£
2. ÔÚÊý¾Ýչʾ½×¶Î¡£Ê¹ÓñêÇ©°üº¬£¬innerhtml µÄ·½Ê½¡£ ......