Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Server]¹ØÓÚ¶Ôʱ¼ä´ÁtimestampÀí½â

Ò»Ö±¶Ôʱ¼ä´ÁµÄ¸ÅÄîÄ£ºý£¬²¢ÇÒÍøÉÏÒ²ÓкܶàÅóÓÑÒ²¶¼ÎóÈÏΪ£ºÊÇÒ»¸öʱ¼ä×ֶΣ¬Ã¿´ÎÔö¼ÓÊý¾Ýʱ£¬ÌîÈ뵱ǰµÄʱ¼äÖµ¡£µ¼ÖÂÒ²Îóµ¼Á˺ܶàÅóÓÑ¡£
 
Õâ´Î¿´Á˺ܶà×ÊÁÏ£¬¾ÀÕýÒ»ÏÂÕâ¸ö´íÎó£¬×Ô¼ºÒ²¸ãÇå³þ£ºÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×Ö£¬Óëʱ¼äºÍÈÕÆÚÎ޹صģ¬ ͨ³£ÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
&nbs ......

SQLʱ¼äº¯ÊýÏê½â

1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate() 
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐµĠdatetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä ......

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 ......

sqlÊý¾Ý±í»º´æ

¡¡1¡¢ÔÚ.net framework 2.0µÄ°²×°Ä¿Â¼ÏÂ
£¨Ä¬ÈÏÊÇWINNT\Microsoft.NET\Framework\v2.0.40607£©£¬Æô¶¯Ò»¸ö½ÐASPnet_regsql.exeµÄÃüÁîÐй¤¾ß£¬±ÈÈ磺
ASPnet_regsql -S localhost –U sa –P 123456 -d Pubs –ed
¡¡¡¡ÉÏÃæµÄÒâ˼ÊÇ£¬Ö¸¶¨Á˱¾µØµÄÊý¾Ý¿â·þÎñÆ÷localhost,²¢Ö¸¶¨Á˵ǽµÄÓû§ÃûºÍÃÜÂ룬²¢ÓòΠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ