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

SQLÓαê¿ìËÙÉÏÊÖ

ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
     ±íA
     0_id           0_name      0_Salary
   Y2007001     ´ï¸ç            3666
   Y2007002      С¶Å           4888
   Y2007003        ´ï¸ç         3666
     ±íB
  a_id               a_salary
 Y2007001        333
Y2007002          444
Y2007003          555      
ÏÖÔÚÏ£ÍûµÃµ½ÕâÑùµÄÊý¾Ý±íAÀïµÄO_Saloary¼ÓÉϱíBµÄA_SalaryÊǵ±Ç°µÄ×ܹ¤×Ê£¬²¢¸üе½±íA¡£
       Äã¿ÉÒÔÓÃÊÓͼÀ´£¬±íÁ¬½ÓϾͿÉÒÔ¡£
       ÏÖÔÚÎÒÃÇ¿¼ÂÇÏÂÈÃSQL×Ô¼ºÀ´´¦Àí£¬Óαê¾ÍÊǺܺõķ½·¨¡£
      
      Ô­Àí£ºÓαê¾ÍÊǰÑÊý¾Ý°´ÕÕÖ¸¶¨ÒªÇóÌáÈ¡³öÏàÓ¦µÄÊý¾Ý¼¯£¬È»ºóÖðÌõ½øÐÐÊý¾Ý´¦Àí¡£
      1.1ÓαêµÄ¸ÅÄî
       Óαê(Cursor)ËüʹÓû§¿ÉÖðÐзÃÎÊÓÉSQL Server·µ»ØµÄ½á¹û¼¯¡£Ê¹ÓÃÓαê(cursor)µÄÒ»¸öÖ÷ÒªµÄÔ­Òò¾ÍÊǰѼ¯ºÏ²Ù×÷ת»»³Éµ¥¸ö¼Ç¼´¦Àí·½Ê½¡£ÓÃSQLÓïÑÔ´ÓÊý¾Ý¿âÖмìË÷Êý¾Ýºó£¬½á¹û·ÅÔÚÄÚ´æµÄÒ»¿éÇøÓòÖУ¬ÇÒ½á¹ûÍùÍùÊÇÒ»¸öº¬Óжà¸ö¼Ç¼µÄ¼¯ºÏ¡£Óαê»úÖÆÔÊÐíÓû§ÔÚSQL serverÄÚÖðÐеطÃÎÊÕâЩ¼Ç¼£¬°´ÕÕÓû§×Ô¼ºµÄÒâÔ¸À´ÏÔʾºÍ´¦ÀíÕâЩ¼Ç¼¡£
       1.2 ÓαêµÄÓŵã
      ´ÓÓα궨Òå¿ÉÒԵõ½ÓαêµÄÈçÏÂÓŵ㣬ÕâЩÓŵãʹÓαêÔÚʵ¼ÊÓ¦ÓÃÖз¢»ÓÁËÖØÒª×÷Óãº
        1£©ÔÊÐí³ÌÐò¶ÔÓɲéѯÓï¾äselect·µ»ØµÄÐм¯ºÏÖеÄÿһÐÐÖ´ÐÐÏàͬ»ò


Ïà¹ØÎĵµ£º

²»´íµÄSQLÃæÊÔÌ⣨¶þ£©

ÎÊÌâÃèÊö£º
±¾ÌâÓõ½ÏÂÃæÈý¸ö¹ØÏµ±í£º
CARD     ½èÊ鿨¡£   CNO ¿¨ºÅ£¬NAME  ÐÕÃû£¬CLASS °à¼¶
BOOKS    ͼÊé¡£     BNO ÊéºÅ£¬BNAME ÊéÃû,AUTHOR ×÷Õߣ¬PRICE µ¥¼Û£¬QUANTITY ¿â´æ²áÊý
BORROW   ½èÊé¼Ç¼¡£ CNO ½èÊ鿨ºÅ£¬BNO ÊéºÅ ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹ØÏµ
ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼­·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØÆ½ºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf ºÍ Data3.ndf£©£¬²¢½«ÕâÈý¸ ......

SQLÓï¾ä¼ÓÈëorder by ×Ó¾äÖ®ºóµÄЧÂÊÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÒ»Õűímytable£¬Êý¾Ý¼Ç¼7000ÍòÌõ£¬ÓÐÈçÏÂÁ½ÌõSQLÓï¾ä
1.
select top 100 * from mytable order by operateDate
2.
select * from (select top 100 * from mytable ) a   order  by a.operateDate
      Æð³õÎÒʹÓõÚÒ»ÌõÓï¾ä²éѯÊý¾Ý£¬²¢Ï£Íû½«µÃµ½µÄ ......

{ת}SQLÓÅ»¯34 Ìõ½¨Òé

(1)  Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò
(
Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ
)
£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àí
from
×Ó¾ä
ÖеıíÃû£¬
from
×Ó¾äÖÐдÔÚ×îºóµÄ±í
(
»ù´¡±í 
driving table)
½«±»×îÏÈ´¦Àí£¬ÔÚ
from
×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ
,
Äã±ØÐëÑ¡
Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í ......

SQL Server 2005 µ¼ÈëºÍµ¼³öÏòµ¼

SQL Server µ¼ÈëºÍµ¼³öÏòµ¼ÌṩÁËÉú³É Microsoft SQL Server 2005 Integration Services (SSIS) °ü×î¼òµ¥µÄ·½·¨¡£SQL Server µ¼ÈëºÍµ¼³öÏòµ¼¿ÉÒÔ·ÃÎʸ÷ÖÖÊý¾ÝÔ´¡£¿ÉÒÔÏòÏÂÁÐÔ´¸´ÖÆÊý¾Ý»ò´ÓÆäÖи´ÖÆÊý¾Ý£º
·   Microsoft SQL Server
·   Æ½ÃæÎļþ
·   Microsoft Off ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ