ããæå¼SQL Server Management Studioï¼æå¾ä¸çè·¯å¾è¿å
¥å¯¼å
¥æ°æ®çé¢ã
ãã导å
¥çæ¶åéè¦å°EXCELçæ件åå¤å¥½ï¼ä¸è½æå¼ãç¹å»ä¸ä¸æ¥ã
ããæ°æ®æºï¼éæ©âMicrosoft Excelâé¤äºEXCELç±»åçæ°æ®ï¼SQLè¿æ¯æå¾å¤å
¶å®æ°æ®æºç±»åã
ããéæ©éè¦å¯¼å
¥çEXCELæ件ãç¹å»æµè§ï¼æ¾å°å¯¼å
¥çæ件确å®ã
ããå次确认æ件路å¾æ²¡æé®é¢ï¼ç¹å»ä¸ä¸æ¥ã
ããé»è®¤ä¸ºæ¯ä½¿ç¨çWINODWS身份éªè¯ï¼æ¹ä¸ºä½¿ç¨SQL身份éªè¯ãè¾å
¥æ°æ®åºå¯ç ï¼æ³¨æï¼æ°æ®åºï¼è¿éççæ¯ä¸æ¯å¯¼å
¥çæ°æ®åºãä¹å¯ä»¥å¨è¿é临æ¶æ¹åï¼éæ©å
¶å®æ°æ®åºã
ããéæ©å¯¼å
¥æ°æ®EXCEL表å
容èå´ï¼è¥æå 个SHEET表ï¼æä¸ä¸ªSHEET表ä¸æäºæ°æ®æ们ä¸æ³å¯¼å
¥ï¼åå¯ä»¥ç¼åæ¥è¯¢æå®çæ°æ®è¿è¡å¯¼å
¥ãç¹å»ä¸ä¸æ¥ã
ããéæ©æ们éè¦å¯¼å
¥çSHEET表ï¼æ¯å¦æå¨è¿éå°SHEET表åæ¹ä¸ºpriceï¼å导å
¥åçé¢çSQLæ°æ®åºè¡¨ä¸ºprice$ãç¹å»è¿å
¥ä¸ä¸æ¥ã
ããç¹å»è¿å
¥ä¸ä¸æ¥ã
ããå¨è¿éå®æ´æ¾ç¤ºäºæ们ç导å
¥çä¿¡æ¯ï¼æ§è¡å
容ï¼å次确认æ 误åï¼ç¹å»å®æï¼å¼å§æ§è¡ã
ããå¯ä»¥çå°ä»»å¡æ§è¡çè¿ç¨åè¿åº¦ã
ããæ§è¡æåï¼æ们å¯ä»¥ççæ§è¡ç»æï¼å·²ä¼ è¾1754è¡ï¼è¡¨ç¤ºä»EXCEL表ä¸å¯¼å
¥1754æ¡æ°æ®ï¼å
æ¬ååæ é¢ãè¿æ ·å°±å®æäºï¼æ§è¡SQLæ¥è¯¢è¯å¥ï¼SELECT * FROM price$å°±å¯ä»¥æ¥ç已导å
¥çæ°æ®å
容ã
温馨提示:内容为网友见解,仅供参考