sql ²éѯÌõ¼þ×Ö¶ÎΪtext»òntext µÄ½â¾ö·½°¸
sql ²éѯÌõ¼þ×Ö¶ÎΪtext»òntextµÃ½â¾ö·½°¸ÒÔ¼°varchar(max)¡¢nvarchar(max)
1¡¢ÔÚMS SQL2005¼°ÒÔÉϵİ汾ÖУ¬¼ÓÈë´óÖµÊý¾ÝÀàÐÍ£¨varchar(max)¡¢nvarchar(max)¡¢varbinary(max) £©¡£´óÖµÊý¾ÝÀàÐÍ×î¶à¿ÉÒÔ´æ´¢2^30-1¸ö×Ö½ÚµÄÊý¾Ý¡£
Õ⼸¸öÊý¾ÝÀàÐÍÔÚÐÐΪÉϺͽÏСµÄÊý¾ÝÀàÐÍ varchar¡¢nvarchar ºÍ varbinary Ïàͬ¡£
΢ÈíµÄ˵·¨ÊÇÓÃÕâ¸öÊý¾ÝÀàÐÍÀ´´úÌæÖ®Ç°µÄtext¡¢ntext ºÍ image Êý¾ÝÀàÐÍ£¬ËüÃÇÖ®¼äµÄ¶ÔÓ¦¹ØÏµÎª£º
varchar(max)-------text;
nvarchar(max)-----ntext;
varbinary(max)----image.
ÓÐÁË´óÖµÊý¾ÝÀàÐÍÖ®ºó£¬ÔÚ¶Ô´óÖµÊý¾Ý²Ù×÷µÄʱºòÒª±ÈÒÔǰÁé»îµÄ¶àÁË¡£±ÈÈ磺֮ǰtextÊDz»ÄÜÓÑlike’µÄ£¬ÓÐÁËvarchar(max)Ö®ºó¾ÍûÓÐÕâЩÎÊÌâÁË£¬ÒòΪvarchar(max)ÔÚÐÐΪÉϺÍvarchar(n)ÉÏÏàͬ£¬ËùÒÔ£¬¿ÉÒÔÓÃÔÚvarcahrµÄ¶¼¿ÉÒÔÓÃÔÚvarchar(max)ÉÏ¡£
ËùÒÔÇëʹÓà varchar(max)¡¢nvarchar(max) ºÍ varbinary(max) Êý¾ÝÀàÐÍ£¬¶ø²»ÒªÊ¹Óà text¡¢ntext ºÍ image Êý¾ÝÀàÐÍ¡£
2¡¢Èç¹ûÐèÒª´¦ÀíÒѾ´æÔÚµÄtextÀàÐÍ µÄ²éѯ ÔòÐèÒª½øÐÐ×Ö¶Îת»»Ï where cast(text as varchar)
3¡¢ÊµÀýÈçÏ£¬ÆäÖÐi_itemΪntext
select * from IP_Investigate
where I_InvestigateID in (select IS_ID from IP_InvestigateStatus
where IS_Name like 'tomcat%') and cast(i_item as varchar)='1'
update IP_Investigate
set i_order=5
where I_InvestigateID in (select IS_ID from IP_InvestigateStatus
where IS_Name like 'tomcat%') and cast(i_item as varchar)='5'
Ïà¹ØÎĵµ£º
select Convert( varchar(20) , ʱ¼ä×Ö¶Î , ¸ñʽ ) from ±í È磺select Convert(varchar(20),LOGIN_DATE,112) from dbo.C_PARTY_CLIENT 100£ºJun 22 2009 12:00AM 101£º06/22/2009 102£º2009.06.22 103£º22/06/2009 104£º22.06.2009 105£º22-06-2009 106£º22
select Convert(varchar(20),<ʱ¼ä×Ö¶Î>,<¸ñʽ>) f ......
1¡¢ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_valueÔÚ check_expressionΪNULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë check_expresssion ¾ßÓÐÏàͬµÄÀàÐÍ¡£
·µ»ØÀàÐÍ
·µ»ØÓë check_expression Ï ......
1.Ìõ¼þ¿ØÖÆ
1.1 if .. then .. end if
if Ìõ¼þ then
Óï¾ä¶Î£»
end if;
1.2 if .. then .. else .. end if
if Ìõ¼þ then
Óï¾ä¶Î£»
else
Óï¾ä¶Î£»
end if;
1.3 ifǶÌ×
2.Ñ»·¿ØÖÆ
2.1 loop .. exit .. end loop
loop
& ......
1.´´½¨¹ý³Ì
create or replace procedure ¹ý³ÌÃû as
ÉùÃ÷Óï¾ä¶Î;
begin
Ö´ÐÐÓï¾ä¶Î;
exception
Òì³£´¦ÀíÓï¾ä¶Î;
end;
2. ´ø²ÎÊýµÄ¹ý³Ì
²ÎÊýÀàÐÍ3ÖÖ
in²ÎÊý£º¶ÁÈë²ÎÊý£¬Ö÷³ÌÐòÏò¹ý³Ì´«µÝ²ÎÊýÖµ
out²ÎÊý£ºÊä³ö²ÎÊý£¬¹ý³ÌÏòÖ÷³ÌÐò´«µÝ²ÎÊýÖµ
in out²ÎÊý£ºË«Ïò²ÎÊý
¶¨Òå ......
Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü
ÉÏһƪ / ÏÂһƪ 2008-09-04 11:25:01
²é¿´( 1991 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_ ......