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

Oracle SQL*PlusµÄ»·¾³ÅäÖ㨸ü¸ÄÐÐ¿í£©

µ±ÎÒÃÇÓÃoracleµÄSQL*Plus¹¤¾ßÊäÈësqlÓï¾äµÄʱºò£¬SQL*PlusµÄĬÈÏÉèÖÃ×ÜÓÐЩ²»ºÏÀíµÄµØ·½£¬´ËʱÎÒÃÇͨ¹ýÒÔÏÂһЩ·½·¨¸Ä½ø£º
1¡¢¿ÉÒÔÔËÓÃSQL*Plus×ÔÉíһЩÓï¾ä¸Ä±ä»·¾³²ÎÊý¡£
     SQL>  set linesize 900 ;   /* ¸ü¸ÄÏÔʾµÄ¿í¶È, ÉèÖóÉ900ºó, Ò»ÐÐÊý¾Ý¾Í²»»á·ÖÁ½ÐÐÏÔʾÁË */
     SQL>  set pagesize 20 ;   /* ÉèÖÃÒ³Ãæ¼Ç¼ÌõÊý(ÿҳ20Ìõ¼Ç¼)£º */
2¡¢¿ÉÒÔµã»÷SQL*Plus²Ëµ¥À¸µÄÑ¡Ïî——»·¾³£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖЗ—É趨ѡÏҲ¿ÉÒÔÕÒµ½linesize¡¢pagesizeµÈ²ÎÊý£¬È»ºóÔÚÖµÇøÓò
     ÊäÈëÐèÒªÉ趨µÄÖµ¡£


Ïà¹ØÎĵµ£º

SQL ServerÖлã×ܹ¦ÄܵÄʹÓÃGROUPING,ROLLUPºÍCUBE

1.Óà CUBE »ã×ÜÊý¾Ý
 CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÊǶàάÊý¾Ý¼¯¡£¶àάÊý¾Ý¼¯ÊÇÊÂʵÊý¾ÝµÄÀ©Õ¹£¬ÊÂʵÊý¾Ý¼´¼Ç¼¸ö±ðʼþµÄÊý¾Ý¡£À©Õ¹½¨Á¢ÔÚÓû§´òËã·ÖÎöµÄÁÐÉÏ¡£ÕâЩÁб»³ÆÎªÎ¬¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸ö½á¹û¼¯£¬ÆäÖаüº¬Á˸÷ά¶ÈµÄËùÓпÉÄÜ×éºÏµÄ½»²æ±í¸ñ¡£ CUBE ÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ ......

SQLÖÐDATEADDºÍDATEDIFFµÄÓ÷¨

¹Ì¶¨ÈÕÆÚ¼õÒ»¸öÔ£¨ÈÕ¡¢Ä꣩
dateadd(±í´ïʽ1£¬±í´ïʽ2£¬±í´ïʽ3£©
±í´ïʽ1ΪMM»òYY»òDD
±í´ïʽ2Ϊ1
±í´ïʽ3ΪҪ¼õµÄÈÕÆÚ Ò»¸öÔµĵÚÒ»Ìì µÚÒ»¸öÀý×Ó£¬ÎÒ½«¸æËßÄãÈçºÎ´Óµ±Ç°ÈÕÆÚÈ¥Õâ¸öÔµÄ×îºóÒ»Ìì¡£Çë×¢Ò⣺Õâ¸öÀý×ÓÒÔ¼°ÕâÆªÎÄÕÂÖÐµÄÆäËûÀý×Ó¶¼½«Ö»Ê¹ÓÃDATEDIFFºÍDATEADDº¯ÊýÀ´¼ÆËãÎÒÃÇÏëÒªµÄÈÕ ......

sql server ÈçºÎÖ´ÐÐÒ»Ïî¼Æ»®ÈÎÎñ

ÿÌ죬ÿÖܵÄÖ´ÐÐ
±ÈÈç¿ÉÒÔ¿ØÖÆÃ¿ÌìÖ»ÄÜͶƱÈý´Î¡£
ÿÖÜҪͳ¼ÆÒ»ÏÂͶƱÊý¡£
1¡¢Äã±ØÐ뿪Æô´úÀí·þÎñsql server agent
2¡¢ÔÚÆóÒµ¹ÜÀíÆ÷À´ò¿ª“¹ÜÀí—>sqlserver´úÀí—>×÷Òµ”£¬ÐÂÔö×÷Òµ£¬Ð½¨“²½Ö蔣¬ÔÚ²½ÖèÀïÌîÈëÄãÒª×ªÒÆµÄSQLÓï¾äµ½“ÃüÁòÀȻºóн¨“µ ......

JSPÖÐÁ¬½ÓSQL 2000Êý¾Ý¿âµÄÎÊÌâ×ܽá

 
ÓÉÓÚϵͳÐèÇó£¬×î½üÔÚ¿ª·¢¹ý³ÌÖн«ÏµÍ³´ÓÔ­À´µÄMySQL×ªÒÆµ½SQL
2000Ï£¬ÆäÖÐÓöµ½ÁËÖî¶àÎÊÌ⣬»¨·ÑÁËÎÒ²»ÉÙʱ¼ä¡£ÏÖÔÚ°ÑÎҵľ­ÑéÄóöÀ´¸æËß´ó¼Ò£¬ºÃÈôó¼ÒÉÙ×ßÍä·£¬½ÚԼʱ¼ä¡£
¡¡¡¡Ê×ÏÈÊÇSQL
2000Êý¾Ý¿âµÄ°²×°ÎÊÌ⣬ÔÚ´ËÎÒÖ÷Òª½²Ð©¹ØÓÚSQL 2000µÄ°æ±¾Óë²Ù×÷ϵͳµÄ¼æÈÝÐÔÎÊÌ⣺SQL
2000×ܹ²ÓÐ7¸ö²»Í¬°æ±¾£¬ÊÊ ......

ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005

 
ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005
 
Ò»¡¢Òª½øÐÐÁ½¸öµØ·½µÄÉèÖÃ
1         µã¿ªÊ¼—³ÌÐò—sql server 2005 –ÅäÖù¤¾ß—sql server 2005Ó¦ÓÃÅäÖÃÆ÷ ,Èçͼ£º
 
 
 
Ñ¡±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½ÓÖеĠ ½öʹÓÃtcp/ip»ò& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ