ÎÞ·¨Á¬½Óа²×°µÄ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£¬µ«È´Ã»ÓÐÓöµ½¹ýÕâ¸öÎÊÌ⡣ͬһ¸öÈí¼þ£¬ÔÚ²»Í¬µÄ»úÆ÷Éϰ²×°£¬·À»ðǽµÄ´¦Àí·½Ê½»á²»Ò»Ñù£¬Õæ¹»Ææ¹ÖµÄ¡£
Ïà¹ØÎĵµ£º
ÀýÈç²éÕÒ¹ØÓÚ¶Ô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ÖÐûÓÐ ......
ÔÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“° ......
SQL Server 2005Òý½øÁËÒ»¸öºÜÓмÛÖµµÄеÄTransact-SQLÓïÑÔ×é¼þ£ºÒ»¸öͨÓñí±í´ïʽ£¨Common Table Expression£¬CTE£©£¬ËüÊÇÅÉÉú±íºÍÊÓͼµÄÒ»¸ö±ã½ÝµÄÌæ´ú¡£Í¨¹ýʹÓÃCTE£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ò»¸öÃüÃû½á¹û¼¯À´ÔÚSELECT¡¢INSERT¡¢UPDATEºÍDELETEÓï¾äÖÐÒýÓ㬶øÎÞÐë±£´æ½á¹û¼¯½á¹¹µÄÈκÎÔªÊý¾Ý¡£ÔÚ±¾ÎÄÖУ¬ÎÒ½«²ûÊöÈçºÎÔÚSQL Server 2 ......
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 ......
ÔÚ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*/
±í ......