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

oraleÖÐsqlÓï¾ä¶ÔnullÖµµÄ´¦Àí

µÚÒ»ÖÖ·½·¨£ºÊ¹ÓÃNVLº¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL(exp1,exp2)¡£ÆäÖвÎÊýexp1ºÍexp2¿ÉÒÔʹÈÎÒâÊý¾ÝµÄÀàÐÍ£¬µ«Á½ÕßÊý¾ÝÀàÐͱØÐëÆ¥Å䡣ʾÀý£ºselect ename,sal,comm,sal+nvl(comm,0) as salary from emp;
µÚ¶þÖÖ·½·¨£ºÊ¹ÓÃNVL2º¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL2(exp1,exp2,exp3)¡£ÕâÊÇoracle9iÐÂÔö¼ÓµÄº¯Êý¡£Èç¹ûexp1²»ÊÇNULL£¬Ôò·µ»Øexp2£»Èç¹ûexp1ÊÇNULL£¬Ôò·µ»Øexp3¡£µ±È»Êý¾ÝÀàÐÍҪƥÅ䣬¸üҪעÒâµÄÊÇexp2ºÍexp3µÄÀàÐͲ»ÄÜÊÇLONGÀàÐ͵ġ£Ê¾Àý£ºselect ename,nvl2(comm,sal+comm,sal) from emp;


Ïà¹ØÎĵµ£º

SQL ServerÖд洢¹ý³Ì±ÈÖ±½ÓÔËÐÐSQLÓï¾äÂýµÄÔ­Òò

ÔںܶàµÄ×ÊÁÏÖж¼ÃèÊö˵SQLSERVERµÄ´æ´¢¹ý³Ì½ÏÆÕͨµÄSQLÓï¾äÓÐÒÔÏÂÓŵ㣺
1.       ´æ´¢¹ý³ÌÖ»ÔÚ´´Ôìʱ½øÐбàÒë¼´¿É£¬ÒÔºóÿ´ÎÖ´Ðд洢¹ý³Ì¶¼²»ÐèÔÙÖØбàÒ룬¶øÎÒÃÇͨ³£Ê¹ÓõÄSQLÓï¾äÿִÐÐÒ»´Î¾Í±àÒëÒ»´Î,ËùÒÔʹÓô洢¹ý³Ì¿ÉÌá¸ßÊý¾Ý¿âÖ´ÐÐËٶȡ£
2.     &nbs ......

·¢²¼DBATools For PL/SQL Developer V1.1.0 Beta 1 °æ

      Èí¼þÊÇÃâ·ÑʹÓõģ¬×Ô¼º¹¤×÷ÖÐÒ²Ò»Ö±Óã¬Óкܶ๦ÄÜÏëÔö¼Ó£¬ÓÉÓÚʱ¼äÔ­ÒòûȥÕûÀíÐèÇó¡£×Ô´ÓÈ¥Äê·¢²¼V1.0.0°æºóûÓÐÔÚ·¢²¼ÁË£¬±¾´ÎÖ÷ÒªÊÇÔö¼ÓÁ˽âÃÜOracle10g¼ÓÃܶÔÏñµÄ¹¦ÄÜ£¬ÁíÍâ×öÁËһЩСµÄÓÅ»¯£¬·¢ÉÏÀ´Óë´ó¼Ò·ÖÏíһϣ¬ÒòΪÊÇBeta°æ£¬ËùÒÔÒ²Çë´ó¼ÒÁ½⣬Èç¹ûÔÚʹÓýâÃܹ¦ÄÜʱÓöµ½ÎÊÌâ¿ÉÒÔ·¢E ......

PL/SQLʹÓü¼ÇÉ£¨PL/SQL 7.0.0ÒÔÉÏ£©

 
1¡¢PL
/SQL
Developer¼ÇסµÇ½ÃÜÂë
   ÔÚʹÓÃPL
/SQL
Developerʱ£¬ÎªÁ˹¤×÷·½±ãÏ£ÍûPL
/SQL
Developer¼ÇסµÇ¼OracleµÄÓû§ÃûºÍÃÜÂ룻
ÉèÖ÷½·¨£ºPL
/SQL
Developer 7.1.4 ->tools->Preferences->Oracle->Logon History
£¬ “Store history”ÊÇĬÈϹ´Ñ¡µÄ£¬¹´ÉÏ ......

SQL Server 2005ÖÐдÎļþµÄ·½·¨

--´´½¨Ð´ÎļþµÄ´æ´¢¹ý³Ì
ALTER proc [dbo].[p_movefile]
 @filename varchar(1000),--Òª²Ù×÷µÄÎı¾ÎļþÃû  
 @text varchar(8000),   --ҪдÈëµÄÄÚÈÝ
 @obj int
as  
begin
 declare @err  int,
   @src  varchar(255),
 &n ......

ÁÙʱ±íÔÚSQL ServerºÍMySqlÖд´½¨µÄ·½·¨

SQL Server´´½¨ÁÙʱ±í£º
´´½¨ÁÙʱ±í
·½·¨Ò»£º
create table #ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
create table ##ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
·½·¨¶þ£º
select * into #ÁÙʱ±íÃû from ÄãµÄ±í;
select * into ##ÁÙʱ±íÃû from ÄãµÄ±í;
×¢£ºÒÔÉϵÄ#´ú±í¾Ö²¿ÁÙʱ±í£¬##´ú±íÈ«¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ