ä¸ãå·¥å ·:SQL Server 2008ãSQL Server Management Studio
äºãæä½æ¥éª¤ï¼
1.ç»å½å°æ°æ®åº SQL Server 2008 ä¸ï¼å¾çä¸çâ.â表示localçææã
2.å¨éè¦æä½çæ°æ®åºä¸å³é®ä¹åéæ©ä»»å¡åä¹å导åºæ°æ®åè½ï¼ä¾åä¸ä»¥DB_Testæ°æ®åºåæ¼ç¤ºã
3.è¿å ¥SQL Server 2008çæ°æ®å¯¼å ¥ä¸å¯¼åºå导ï¼ä¹åç¹å»ä¸ä¸æ¥(next)ã
4.éæ©æå¡å¨å称为localï¼ä¾åä¸æ¯'.'ï¼æ°æ®åºä¸ºDB_Testãå®é ä¸ä»¥çå®æ°æ®åºä¸ºä¸»ï¼ä»¥ä¸åªæ¯æ¼ç¤ºå®ä¾ï¼ä¹åç¹å»ä¸ä¸æ¥ã
5.éæ©å¯¼åºçç®æ 为Excelï¼æ°æ®åºä¸ºé»è®¤å¼å³å¯ï¼éæ©Excelçæ件路å¾ä¹åç¹å»ä¸ä¸æ¥æé®ç»§ç»æä½ã
6.ä¸ä¸ä¸ªé¡µé¢éç¨é»è®¤è®¾ç½®ï¼ä¹åç¹å»ä¸ä¸æ¥æé®ãéæ©æ°æ®åºä¸å³å°è¦å¯¼åºæ°æ®çå ·ä½è¡¨ï¼å¯ä»¥éè¿é¢è§æé®æ¥çæ°æ®ï¼ä¹åç¹å»ä¸ä¸æ¥æé®ã
7.ä¹åç¹å»ä¸ä¸æ¥ï¼åä¹åéæ©ç«å³è¿è¡æé®ä¸ä¸ä¸æ¥ãåç¹å»å®ææé®ï¼æåç¹å»å ³éæé®å³å¯ã
8.æåï¼æå¼Excelè¡¨æ ¼æ件ï¼éªè¯æ°æ®ï¼å¯ä»¥çå°å¾çä¸å·²ç»ææ°æ®äºï¼è¿æ ·SQL Server 2008å·²ç»æ£ç¡®å¯¼åºæ°æ®æ¥äºã