ÎÞ·¨Á¬½Óа²×°µÄ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£¬µ«È´Ã»ÓÐÓöµ½¹ýÕâ¸öÎÊÌ⡣ͬһ¸öÈí¼þ£¬ÔÚ²»Í¬µÄ»úÆ÷Éϰ²×°£¬·À»ðǽµÄ´¦Àí·½Ê½»á²»Ò»Ñù£¬Õæ¹»Ææ¹ÖµÄ¡£
Ïà¹ØÎĵµ£º
[C#]
public void RunSqlTransaction(string myConnString)
{
SqlConnection myConnection = new SqlConnection(myConnString);
myConnection.Open();
SqlCommand myCommand = myConnection.CreateCommand();
SqlTransaction m ......
ÔÎÄ£ºhttp://hi.baidu.com/scoful/blog/item/963339d793cfe92506088b11.html
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
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*/
±í ......
SQL SERVER¶¨Ê±×÷ÒµµÄÉèÖ÷½·¨
תÌù×Ô£º http://www.cnblogs.com/stephencat/archive/2006/08/24/484918.html
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ,
¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
1¡¢¹ ......