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

ÎÞ·¨Á¬½Óа²×°µÄSQL Server 2005 Express

½ñÌìÔÚµçÄÔÉϰ²×°ÁËVisual Studio 2005£¬ÀïÃæ×Ô´øÁËÒ»¸öSQL Server 2005 Express¡£°²×°Íê³ÉÖ®ºó½øÈëVS£¬Ð½¨Ò»¸öÊý¾Ý¿âÏîÄ¿£¬Ôړн¨Êý¾Ý¿âÒýÓÔһ²½Óöµ½ÁËÆæ¹ÖµÄÎÊÌâ¡£
ÔÚ·þÎñÆ÷ÃûµÄÏÂÀ­ÁбíÀïÃæ£¬Í¨¹ýµã»÷“ˢД°´Å¥¿ÉÒÔÏÔʾµ±Ç°Í¨¹ýÍøÂç¿ÉÒÔÁ¬½Óµ½µÄÊý¾Ý¿âµÄÐÅÏ¢£¬ÆäÖÐÓÐÎÒµÄÖ÷»ú¡£È»¶ø£¬Ñ¡ÔñÁËÎÒµÄÖ÷»úÖ®ºó£¬“Á¬½Óµ½Ò»¸öÊý¾Ý¿â”ÖÐÈ´²»ÄÜÏÔʾÎÒÖ÷»úÊý¾Ý¿âÀïÃæµÄ±íµÄÐÅÏ¢£¬²¢ÇÒ»á³öÏÖ³ö´íÌáʾ¡£ËäÈ»ÕâÖ»ÊÇһ̨а²×°µÄÊý¾Ý¿â£¬µ«ÀïÃæ´æÔÚһЩ³õʼ»¯ºÃµÄÊý¾Ý¿âµÄ£¨Èçtempdb£©¡£
ÔÚÍøÉϲéÁËºÜ¶à¹ØÓÚ“ÎÞ·¨Á¬½ÓSQL Server 2005”µÄ×ÊÁÏ£¬ÆäÖÐÓÐһЩ½éÉÜ˵ÓпÉÄÜÊÇÒòΪSQL ServerµÄ“Ô¶³ÌÁ¬½Ó”±»½ûÓÃÁË£¬Í¨¹ý“¿ªÊ¼”->“Microsoft SQL Server 2005”->“ÅäÖù¤¾ß”->“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”°ÑSQL ServerµÄ“Ô¶³ÌÁ¬½Ó”ÆðÆðÀ´¡£µ«ÎÒ·¢ÏÖÎÒÕą̂Êý¾Ý¿âµÄ“Ô¶³ÌÁ¬½Ó”ĬÈÏÊÇ¿ªÆô×ŵġ£
ºóÀ´Ïëµ½£¬¼ÈÈ»·þÎñÒѾ­¿ªÆôÁË£¬¶øÇÒÔ¶³ÌÁ¬½ÓÒ²¿ªÆôÁË£¬ÔÙ·ÃÎʲ»µ½Êý¾Ý¿âµÄ»°ÓпÉÄÜÊÇÍøÂçÎÊÌâµ¼Öµġ£¼´Ê¹ÊDZ¾»ú£¬µ«¾ÝÎÒµÄÀí½â£¬¶ÔÊý¾Ý¿âµÄ·ÃÎÊÊÇͨ¹ýÍøÂç¶Ë¿ÚÀ´½øÐеġ£ÓÚÊÇÎÒ°ÑSQL ServerÏà¹ØµÄ·þÎñ¶¼Ìí¼Óµ½·À»ðǽµÄÀýÍâ³ÌÐòµ±ÖУ¬ÎÊÌ⻹¾ÍÕæµÄ½â¾öÁË¡£
¾õµÃWindowsÄÚÖõķÀ»ðǽÐÐÎªÍ¦Ææ¹ÖµÄ¡£ÎÒÒÔǰÔÚÆäËûµçÄÔÉÏÒ²×°¹ýVS 2005ºÍSQL Server 2005 Express£¬µ«È´Ã»ÓÐÓöµ½¹ýÕâ¸öÎÊÌ⡣ͬһ¸öÈí¼þ£¬ÔÚ²»Í¬µÄ»úÆ÷Éϰ²×°£¬·À»ðǽµÄ´¦Àí·½Ê½»á²»Ò»Ñù£¬Õæ¹»Ææ¹ÖµÄ¡£


Ïà¹ØÎĵµ£º

¸ù¾Ýµ±Ç°µÈ´ýʼþÃû²éÕÒÔì³É¸ÃµÈ´ýʼþµÄSQL

ÀýÈç²éÕÒ¹ØÓÚ¶Ôlibrary ....µÈ´ýʼþÓй±Ï×µÄSQL
select sql_text from V$sqlarea  where (address,hash_value) in
(select sql_address,sql_hash_value from v$session  where event like 'library%');
´ËÓï¾äÖ»ÄÜÔËÐÐÓÚ10g°æ±¾ÒÔÉÏ£¬ÒòΪ10gÖÐv$sessionÊÓͼ°üº¬Á˵ȴýʼþµÄÐÅÏ¢ÁË£¬9iÖÐûÓÐ ......

´´½¨SQL SERVER 2005ÐÂÕË»§

 Ô­ÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“° ......

ÓÃSQL Server 2005 CTE¼ò»¯²éѯ

SQL Server 2005Òý½øÁËÒ»¸öºÜÓмÛÖµµÄеÄTransact-SQLÓïÑÔ×é¼þ£ºÒ»¸öͨÓñí±í´ïʽ£¨Common Table Expression£¬CTE£©£¬ËüÊÇÅÉÉú±íºÍÊÓͼµÄÒ»¸ö±ã½ÝµÄÌæ´ú¡£Í¨¹ýʹÓÃCTE£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ò»¸öÃüÃû½á¹û¼¯À´ÔÚSELECT¡¢INSERT¡¢UPDATEºÍDELETEÓï¾äÖÐÒýÓ㬶øÎÞÐë±£´æ½á¹û¼¯½á¹¹µÄÈκÎÔªÊý¾Ý¡£ÔÚ±¾ÎÄÖУ¬ÎÒ½«²ûÊöÈçºÎÔÚSQL Server 2 ......

SQL ServerʹÓÃBulk Insert°ÑÒ»¸öÎı¾µ¼Èëµ½Êý¾Ý¿â

 
This is very common request recently – How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the solution in quick steps.
CSV stands for Comma Separated Values, sometimes also called Co ......

³£¼ûOracle HINTµÄÓ÷¨ SQLÓÅ»¯

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO=’SCOTT’;
2. /*+FIRST_ROWS*/
±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ