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

°ïæ½âÊÍÒ»ÌõSQLÓï¾ä

SQL code:

SQL> select translate('a39as78900d0123456789d','0123456789','') from dual;

T
-

Ϊʲô½á¹û²»ÊÇ£º
REPLA
-----
aasdd



Ò»¡¢Óï·¨£º
TRANSLATE(string,from_str,to_str)
¶þ¡¢Ä¿µÄ
·µ»Ø½«£¨ËùÓгöÏֵģ©from_strÖеÄÿ¸ö×Ö·ûÌæ»»Îªto_strÖеÄÏàÓ¦×Ö·ûÒÔºóµÄstring¡£TRANSLATE ÊÇ REPLACE ËùÌṩµÄ¹¦ÄܵÄÒ»¸ö³¬¼¯¡£Èç¹û from_str ±È to_str ³¤£¬ÄÇôÔÚ from_str Öжø²»ÔÚ to_str ÖеĶîÍâ×Ö·û½«´Ó string Öб»É¾³ý£¬ÒòΪËüÃÇûÓÐÏàÓ¦µÄÌæ»»×Ö·û¡£to_str ²»ÄÜΪ¿Õ¡£Oracle ½«¿Õ×Ö·û´®½âÊÍΪ NULL£¬²¢ÇÒÈç¹ûTRANSLATE ÖеÄÈκβÎÊýΪNULL£¬ÄÇô½á¹ûÒ²ÊÇ NULL¡£
Èý¡¢ÔÊÐíʹÓõÄλÖÃ
¹ý³ÌÐÔÓï¾äºÍSQLÓï¾ä¡£

ÎÊÌâ¾ÍÔÚ£º
to_str ²»ÄÜΪ¿Õ¡£Oracle ½«¿Õ×Ö·û´®½âÊÍΪ NULL£¬²¢ÇÒÈç¹ûTRANSLATE ÖеÄÈκβÎÊýΪNULL£¬ÄÇô½á¹ûÒ²ÊÇ NULL¡£


ÒýÓÃ
SQL> select replace(translate('a39as78900d0123456789d','0123456789',' '),' ','') from dual;

REPLACE(TR
----------
aasdd

ºÇºÇ£¬·Ç³£¸Ðл¡£


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

sql º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - MS-SQL Server / »ù´¡Àà

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql=''
if (@username<>null and @username ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - .NET¼¼Êõ / ASP.NET

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50), 
@companyname varchar(50), 
@endtime varchar(1) 
AS 
declare @sql varchar(1000) 
set @sql=''  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ