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

PL/SQL DEVELOPER »ù±¾Ó÷¨Ïê½â£¨×ª£©

PL/SQL DEVELOPER »ù±¾Ó÷¨Ïê½â(½¨Òéд¹ýµÚÒ»¸ö´æ´¢¹ý³ÌºóµÄ³õÊֱضÁ)
  
ÓùýoracleµÄ¶¼±§Ô¹£¬ÎªÁËÎȶ¨ ËüÌṩµÄͼÐλ¯²Ù×÷ ËÙ¶ÈÂýµÄÈÃÈËÉËÐÄѽ£¬p4+128MµÄ»úÆ÷Ö»ÒªÆô¶¯Ò»¸ö
  
oracle·þÎñ¾Í¹»ÈÃÈËÉËÐĵģ¬ÔÙÔÚdba studioÀïÃæ²Ù×÷ÕæÄÜÈÃÈ˿ޡ£
  pl/sql developerÕýÊǽâ¾öÕâ¸öÎÊÌâµÄ:¹¦ÄÜÇ¿£¬·½±ã£¬¿ì¡£ÓÃÁËÖ®ºó¾ø¶ÔÀë²»¿ªËü£¡
ËüµÄÖ÷ҪǿÏîÈçÏ£º
  
Ò».±à¼­±íÊý¾Ý(ä¯ÀÀ±íÊýÊý¾Ý×ÔÈ»²»ÔÚ»°ÏÂ)
¶þ.ÔÚsql plusÏÂд³¤µÄÓï¾äʱÊÇ·ñÓÐЩÐÄ·³£¬ÔÚÕâÀïÒ»Ñù¸ã¶¨¡£
Èý.д´æ´¢¹ý³Ì£¬²¢µ÷ÊÔ¡£Èç¹ûÊÀ½çÉÏûÓÐsql/plus dev£¬Õæ²»ÖªµÀÔõôµ÷ÊÔ¼¸°ÙÐеĴ洢¹ý³Ì¡£ËµÕâÖÖÇé¿öЧ
  
ÂÊÌá¸ßÁËÊ®±¶¾ø²»Îª¹ý°É¡£
  
ÏÂÃæ¾ßÌå˵Ã÷£º
Ò»¡£×ó±ßµÄä¯ÀÀ´°¿ÚÑ¡Ôñ tables £¬»áÁгöËùÓÐµÄ±í£¬Ñ¡Ôñ±íÓÒ»÷Êó±êÑ¡Öв˵¥"Edit Data",Óұ߻áÓÐÒ»¸öÐÂ
  
µÄ´°¿Ú£¬Áгö±íµÄËùÓÐÊý¾Ý¡£
¿´±íµÄÊý¾ÝÉÏ·½Óиö¹¤¾ßÌõ£¬Í¼±ê·Ö±ðΪ“ËøÐΔ£¬“Ôö¼Ó£¨+£©”£¬“ɾ³ý£¨-£©”£¬“±£´æ£¨¹´ÐΣ©”¡£
ÐÞ¸ÄÊý¾ÝºóÔõôÌá½»ÐÞ¸ÄÄØ£¿
1.µã“¹´ÐΔ,±£´æÊý¾Ý¡£
2.¿´¹¤¾ßÀ¸µÄµÚ¶þÀ¸£¬ÓÐÁ½¸öºÃ¶«¶«£¬Í¼±ê²»ºÃÃèÊö¹þ£¬Äã°ÑÊó±ê·ÅÔÚÕâÁ½¸ö°´Å¥Í¼±êÉÏ£¬»áÏÔʾ“
  
commit(F10)","rollback(shift+F10)" ¡£commit¾ÍÌá½»Êý¾ÝÐÞ¸ÄÁË,µãÖ®¡£
ok?^_^  dba studioÀïÃæºÃÏñ²»ÄÜÕ³Ìù¸´ÖÆÊý¾Ý£¬ÕâÀïÏëÔõôcopy¾ÍÔõôcopy^_^
  
¶þ¡£ new ->command window ->Ï൱ÓÚsql plus,ÓÃÆðÀ´µ±È»±Èsql plusˬ¡£
  
Èý¡£´æ´¢¹ý³Ì
ËùÓú¯Êý˵Ã÷
¹¦ÄÜ£ºÇóºÍÓë²î
Ô­ÐΣºGetSumAndSub(p1 in number , p2 in number ,m out number , b out number)   
²ÎÊý£ºm=p1+p2  b=p1-p2
  
1.ÏȽ¨´æ´¢¹ý³Ì  
×ó±ßµÄä¯ÀÀ´°¿ÚÑ¡Ôñ procedures £¬»áÁгöËùÓеĴ洢¹ý³Ì£¬ÓÒ»÷Îļþ¼Ðproceduresµ¥»÷²Ëµ¥“new",µ¯³ö
  
template wizard´°¿Ú, name¿òÖÐÊäÈë GetSumAndSub ,parametersÖÐÌîÈ룺 p1 in number , p2 in number ,m  
  
out number , b out number  ¡£µ¥»÷ok£¬Óұ߳öÏÖ½¨Á¢´æ´¢¹ý³ÌµÄ´úÂë´°¿Ú¡£ÆäÖÐÄÚÈÝΪ´´½¨´æ´¢¹ý³ÌµÄÓï¾ä
  
¡£
ÔÚbegin end Ö®¼äÊäÈë¾ßÌåÄÚÈÝ£¬×îºóÈçÏ£»
create o


Ïà¹ØÎĵµ£º

sql group by Óë havingµÄÓ÷¨

1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔ­Ôò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃæ£¨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A    B
1    abc
1    bcd
1    asdfg
 Èç¹ûÓÐÈ ......

ÔÚ°²×°SQL Server2005 ÎÊÌâÐÅÏ¢£º

"SQL Server °²×°³ÌÐòÎÞ·¨»ñÈ¡ ASPNET ÕÊ»§µÄϵͳÕÊ»§ÐÅÏ¢"
½â¾ö°ì·¨£º
ÓÃaspnet_regiisʵÓù¤¾ßÐ¶ÔØºÍÖØÐ°²×°Ò»Ï¾ͿÉÒÔÁË¡£
¾ßÌåµÄ²Ù×÷£º
1¡¢½øÈëCMD£º
C:\windows\microsoft.net\framework\v2.0.50727Îļþ¼ÐÏ£¬ÔËÐÐaspnet_regiis -uÐ¶ÔØ
È»ºóÔËÐÐaspnet_regiis -i ÖØÐ°²×°£¬ÉÏÊöÎÊÌâ¼´¿É½â¾ö¡£
2¡¢C:\WINDOWS\ ......

Linq to SQL DataContext Lifetime Management


Linq to SQL uses a DataContext to manage it's access to the database as well as tracking changes made to entities retrieved from the database. Linq to SQL has a persistent approach to managing its 'connection' to the database via this data context and it basically assumes that you use a single Dat ......

ÃæÏò OLTP Ó¦ÓóÌÐòµÄÖØÒª SQL Server 2005 ÐÔÄÜÎÊÌâ

ÃæÏò OLTP Ó¦ÓóÌÐòµÄÖØÒª SQL Server 2005 ÐÔÄÜÎÊÌâ
OLTP ¹¤×÷¸ººÉµÄÌØÕ÷ÊÇ´æÔÚ´óÁ¿ÏàËÆµÄСÐÍÊÂÎñ¡£
ÔÚ¼ì²éÊý¾Ý¿âÉè¼Æ¡¢×ÊÔ´ÀûÓúÍϵͳÐÔÄܵÄÖØÒªÐÔʱ£¬ÇëÎñ±ØÀμÇÕâÐ©ÌØÕ÷¡£ÏÂÃæ¼òÊöÃæÏò OLTP
Ó¦ÓóÌÐòµÄÖØÒªÐÔÄÜÆ¿¾±»òȱÏÝ¡£
Êý¾Ý
¿âÉè¼ÆÎÊÌâ
³£Óòéѯ´æÔÚ¹ý¶àµÄ±íÁª½Ó¡£ÔÚ OLTP Ó¦ÓóÌÐòÖйý¶àʹÓÃÁª½Ó½«µ¼ ......

SQLÖÐcase whenµÄÁ½ÖÖʹÓ÷½·¨Ê¾Àý

Case¾ßÓÐÁ½ÖÖ¸ñʽ¡£¼òµ¥Caseº¯ÊýºÍCaseËÑË÷º¯Êý¡£
--¼òµ¥Caseº¯Êý
CASE sex
         WHEN '1' THEN 'ÄÐ'
         WHEN '2' THEN 'Å®'
ELSE 'ÆäËû' END
--CaseËÑË÷º¯Êý
CASE WHEN sex = '1' THEN 'ÄÐ'
  &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ