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

sql CHARINDEXº¯Êý

sql CHARINDEXº¯Êý
SQL Server 2010-01-15 09:01:15 ÔĶÁ888 ÆÀÂÛ0 ×ֺţº´óÖÐС
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ÎÊÌâ¡£


Ïà¹ØÎĵµ£º

dz̸SQL½Ì³ÌÖ®Group byºÍHaving

ÔÚ½éÉÜGROUP BY ºÍ HAVING ×Ó¾äǰ£¬ÎÒÃDZØÐèÏȽ²½²sqlÓïÑÔÖÐÒ»ÖÖÌØÊâµÄº¯Êý£º¾ÛºÏº¯Êý£¬ÀýÈçSUM, COUNT, MAX, AVGµÈ¡£ÕâЩº¯ÊýºÍÆäËüº¯ÊýµÄ¸ù±¾Çø±ð¾ÍÊÇËüÃÇÒ»°ã×÷ÓÃÔÚ¶àÌõ¼Ç¼ÉÏ¡£
      SELECT SUM(population) from bbc
¡¡¡¡ÕâÀïµÄSUM×÷ÓÃÔÚËùÓзµ»Ø¼Ç¼µÄpopulation×Ö¶ÎÉÏ£¬½á¹û¾ÍÊǸòéÑ ......

excelµ¼ÈëSQLʱÌáʾ"Êý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó"


excelµ¼ÈëSQLʱÌáʾ"Êý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó"
ÒÔÏÂÄÚÈÝת×Ô[CSDN]
×î½ü´¦ÀíexcelÊý¾Ýµ¼Èëµ½Sql ServerÖУ¬Ê§°Ü£¬±¨´íÈçÏ £º
×÷ΪԴÁÐ3£¨“²úƷ˵Ã÷”£©µÄÊý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó ¡£
ÎÒµÄexcelÎļþÖÐÓÐÒ»ÁнГ²úƷ˵Ã÷”£¬¾ÍÊÇһЩÎÄ×Ö¡£Sql
server´¦Àíµ¼excelÊý¾ ......

sqlÓï¾äѧϰ±Ê¼Ç(6) ³£ÓÃ×Ö·û´®²Ù×÷º¯Êý

ÕâЩº¯ÊýÔÚϵͳº¯Êý¿ÉÒÔÕÒµ½¡£ÏÂÃæÊÇÎÒÁ·Ï°Ê±Ð´µÄ´úÂ룬°üº¬Á˳£ÓõÄ×Ö·û´®²Ù×÷º¯Êý
/*********************************
³£ÓÃ×Ö·û´®º¯Êý:sqlÖÐûÓÐÊý×éÕâһ˵
*********************************/
--int charindex('ÒªÕÒµÄ×Ö·û´®','Ô´×Ö·û´®',¿ªÊ¼Î»ÖÃ)£¬»ñÈ¡×Ö·û´®ÖÐÖ¸¶¨×Ö·û´®µÄλÖÃ
declare @str varchar(50)
set ......

ʹÓÃjdbcÁ¬½ÓsqlÊý¾Ý¿â

»ù±¾ÉϾÍÊÇÕâЩ²½Ö裺
ÏÂÔØÄãÒªÁ¬½ÓµÄÊý¾Ý¿âµÄJDBCÇý¶¯³ÌÐò£¨driver£©¡£Í¨³£¶¼ÊÇÒ»¸öjarÎļþ£¬¸´ÖƵ½ÄãµÄprojectÀïÃæ£¬È·±£Ê¶±ðÕâ¸ö¿â¾Í¿ÉÒÔÁË¡£
¼ÓÔØÇý¶¯£¬ ²»Í¬µÄÊý¾Ý¿âÐèÒª²»Í¬ JDBC driver¡£
Á¬½ÓÊý¾Ý¿â£¬²»Í¬µÄÊý¾Ý¿âͬÑùÐèÒª²»Í¬µÄJDBC URL¡£
ÏÂÃæ¸ø³öÁ¬½Ó²»Í¬Êý¾Ý¿âµÄÀý×Ó
Á¬½Ó mini SQL
// Establish a ......

SQL SERVER ͼ±íÊý¾Ý¿â

ͼ±í
ͼ±í(ÓֳƹØÏµÍ¼)ÊÇSQL ServerÖÐÒ»ÀàÌØÊâµÄÊý¾Ý¿â¶ÔÏó£¬ËüÌṩ¸øÓû§Ö±¹ÛµØ¹ÜÀíÊý¾Ý¿â±íµÄ·½·¨¡£Í¨¹ýͼ±í£¬Óû§¿ÉÒÔÖ±¹ÛµØ´´½¨¡¢±à¼­Êý¾Ý¿â±íÖ®¼äµÄ¹ØÏµ£¬Ò²¿ÉÒԱ༭±í¼°ÆäÁеÄÊôÐÔ¡£ÀûÓÃÆóÒµ¹ÜÀíÆ÷´´½¨Í¼±íµÄ¾ßÌå²½ÖèÈçÏ£º
(1)ÔÚÆóÒµ¹ÜÀíÆ÷ÖУ¬Õ¹¿ªÖ¸¶¨µÄ·þÎñÆ÷ºÍÊý¾Ý¿â£¬´ò¿ªÒª½¨Á¢µÄͼ±íËùÔÚµÄÊý¾Ý¿â£¬ÓÒ»÷ͼ±íÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ