Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 * Í ......

MySqlµ¼³ösql½Å±¾


mysqlµ¼³ösql½Å±¾ Êղؠ
   ×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈϰ²×°ÔÚC:\Program    Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......

PL/SQL ѧϰ±Ê¼Ç1

PL/SQL ²»¾ß±¸ÊäÈëÊä³öµÄÄÜÁ¦
µ«ÊÇ¿ÉÒÔÒÀ¿¿»·¾³À´Ö´ÐÐÊýÖµµÄÊäÈëÊä³ö¸øPL/SQL ¿é
SQLPLUS »·¾³ÓÃsubstitution variables ºÍ host(bind) variable À´´«ÈëÊýÖµ¸øPL/SQL¿é
substitution variable: such as a preceding ampersand  &a
host(bind) variable : such as a  preceding colon :x
Ìæ ......

sql·ÖÒ³

declare @p int
declare @p1 int
declare @count int
set @p=0
set @p1=10
set @count=2
if(@count<>0 or @count<>1)
set @p=@p1*@count-10
SELECT [t1].[userid], [t1].[username], [t1].[userorder]
from (
    SELECT ROW_NUMBER() OVER (ORDER BY [t0].[userorder]) AS [ROW_NU ......

SQL»ù´¡

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢É¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ