Shunze ¾Ç¶é >¹q¸£¸ê°T¾Ç¨t >¸ê®Æ®wºÞ²z > ¡m¤À¨É¡nExcel 2007»s§@¥i¿é¤J°Ñ¼ÆªºSQL Query¬d¸ß¤u¨ã «¢Åo¡AÁÙ¨S¦³µù¥U©ÎªÌµn¤J¡C½Ð§A[µù¥U|µn¤J]
« ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD » Åã¥Ü¦¨¦C¦L¼Ò¦¡ | ¼W¥[¨ì§Úªº³Ì·R
µoªí·s¥DÃD µoªí¦^ÂÐ
§@ªÌ
¥DÃD
shunze
¤u¤Í§B§B


µù¥U¤é´Á: 2002 04
¨Ó¦Û: ¼é¦Á²×¤î¤§¦a
¤å³¹: 2370

shunze Â÷½u
¡m¤À¨É¡nExcel 2007»s§@¥i¿é¤J°Ñ¼ÆªºSQL Query¬d¸ß¤u¨ã¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

¦b¤½¥q¬Ý¨ì«e½ú¯d¤U¨ÓªºExcel¬d¸ßSQL¤u¨ã¡A
¹ï©ó¨ä¥i¿é¤J°Ñ¼Æ¨Ó¶i¦æ¤¬°Ê¦¡¬d¸ß¡AÁ`ı±o¬Û·í¦n¥Î¡I
¦ý¦Û¤v¹Á¸Õ¥h²£¥Í³o¼Ë¤@­Ó³øªí¤u¨ã¡A«o¬O«ç»ò¼Ë¤]°µ¤£¥X¨Ó...

§ä¤F¦n´X­Ó§«ô¡AÁ`ºâ¦b³o¤@½g¤å³¹¤¤§ä¨ì»s§@ªº¤èªk¡ã


¥´¶}Excel 2007¡A©ó¸ê®Æ->±q¨ä¥¦¨Ó·½¤¤¡A¿ï¾Ü±qMicrosoft Query¡C



©ó¸ê®Æ®w¨Ó·½¤¤¡A¿ï<·s¸ê®Æ®w¨Ó·½>¡C



µM«á¿ïSQL Server¡C



µM«á¿é¤JSQL ServerªºIP¤Î³s¤Jªº±b¸¹±K½X¨Ó¶i¦æ³sµ²¡C



¶¶¤l´ú¸Õ®Éµo²{¡A¦b¶¶¤l¥»¾÷Ä骺SQL Express¡A
­n§ï¿ï¥ÎSQL Server Native Client 10.0ªºÅX°Êµ{¦¡¤~¯à¶¶§Q³sµ²¡C



³sµ²¦¨¥\«á¡A·|­n¨D¿ï¾Ü¨Ï¥Îªºªí®æ¡A
¹w³]ªí®æºØÃþ¹ê¦b¤Ó¦h¡A§Ú­Ì¥i¥H³z¹L¿ï¶µ¡AµM«á¥u¤Ä¿ïªí®æ¨Ó²¤Æ¥i¿ï¥Î¤§¸ê®Æªí¡C



¦b³o­Ó¥Ü½d®×¨Ò¤¤¡A§Ú­Ì´N¿ï¾Ü¥_­·¸ê®Æ®wªºEmployees¸ê®Æªí§a¡C



¿ï¾Ü¦n¸ê®Æªí«á¡A«ö¤USQL«ö¶s¡A§Ú­Ì¦Û¤v¨Ó­×§ïSQL»yªk¡A¼´¥X©Ò¦³Employeesªº¸ê®Æ¡C



«ö¤U½T©w¡A·|¥X²{¤@­ÓSQL QueryµLªk¥H¹Ï§Îªí¥Üªº°T®§¡C
¶â¡A°µ´N¹ï¤F¡I



±µ¤U¨Ó¡A­n¥[°Ñ¼ÆªºÃöÁä¨BÆJ¨ì¤F¡I
©ó·Ç«h¤¤¡A«ö¤U·s¼W·Ç«h¨Ó¼W¥[¤@­Ó°Ñ¼Æ¡C



¦b·s¼W·Ç«hªº³¡¤À¡AÁ`­p¥i¥H¯d¥Õ¡A
Äæ¦ì´N¿ï­n¶i¦æ±ø¥ó¹LÂoªºÄæ¦ì¡A
¹Bºâ¤l´N¨Ì»Ý¨D¨Ó¿ï¾Ü¡AµM«á¦b­Èªº³¡¤À¿é¤J[ ]¡A
¥H¥»¨Ò¨Ó»¡¡A¶¶¤l¥´ºâ¹ïCountry³o­ÓÄæ¦ì¨Ó¶i¦æ±ø¥ó¹LÂo¡C



³o­Ó³¡¥÷¬OÃöÁä¡A¤@©w­n¦b­ÈªºÄæ¦ì¿é¤J[ ]¤~¦æ¡C
«ö¤U½T©w«á¡A´N·|¦h¥X³o­Ó·Ç«hÄæ¦ìªº°Ï¶ô¡C



µM«á§Ú­Ì´N¥i¥H§âQuery¤º®e¶Ç¦^Excel¤F¡ã



¤@«ö¤U±N¸ê®Æ¶Ç¦^Excel¡A´N·|¥X²{¤@­Ó¡§¿é¤J°Ñ¼Æ­È¡¨ªº°T®§¡A
§O²z¥¦¡A§Ú­Ì¤@¼Ë¯d¥Õ«ö¤U½T©w¡C



±µ¤U¨ÓExcel´N·|¸ß°Ý§Ú­Ì¡A¶×¥Xªº¸ê®Æ¤º®e­n©ñ­þùØ¡H
¥Ñ©ó¶¶¤l¥´ºâ¦b²Ä¤@¦C¡A©ñ¸m¤@­Ó¥i¿é¤J°Ñ¼ÆªºÄæ¦ì¡A
©Ò¥H´N§â¶×¥X¤º®e±q²Ä¤T¦C¶}©l©ñ§a¡ã



±µµÛ·|¥X²{¤@­Ó¿é¤J°Ñ¼Æ­Èªº¹ï¸Ü®Ø¡C



´N§â¥¦©ñ¦b²Ä¤@¦CªºBÄæ§a¡C



µM«á¤Ä¿ï¦¹Äæ¦ì¼Æ­È¦³²§°Ê®É¡A´N¥D°Ê¶i¦æ§ó·s¡C



§Ú­Ì¥i¥H¦b²Ä¤@¦C²ÄAÄ檺Àx¦s®æ¿é¤J¡§°ê®a¡¨¡A¥H«K§Ú­ÌÃѧO¡C



Å禬ªº®É­Ô¨ì¤F¡A·í§Ú­Ì¦b²Ä¤@¦CªºBÄæùØ¿é¤JUSA®É¡A¸ê®Æ¤º®e´N·|¦Û°Ê¼´¨úCountry¬°USAªº¸ê®Æ¡C



·í§Ú­Ì¦b²Ä¤@¦CªºBÄæ§ï¿é¤JUK®É¡A¸ê®Æ¤º®e´N·|¦Û°Ê¼´¨úCountryµ¥©óUKªº¸ê®Æ¡C




¬d¸ßªí®æ«Ø¥ß§¹¦¨«á¡A­Y§Ú­Ì»Ý­n­×§ï¸ê®Æ®w¤º®e¡BSQL»yªk©Î¬O¼W´î°Ñ¼Æ¡A
«h¥i¥H¨ì¸ê®Æªº³s½u³]©w¤¤¨Ó¶i¦æ­×§ï¡C






³o­Ó¬Ý¦ü²³æ«o¤S¤£Â²³æªº¥i°Ñ¼Æ¤Æ¤¬°Ê¦¡¬d¸ßÁ`ºâ§¹¦¨Åo¡ã



♥¶¶¤l¦Ñ±Cªººô©ç¡A½Ð¦hÃö·Ó¡ã

If you don't like something, change it.
If you can't change it, change your attitude.
Don't complain!




2013-06-04, 19:48 shunze ªº­Ó¤H¸ê®Æ §â shunze ¥[¤J¦n¤Í¦Cªí µo°eEmailµ¹ shunze ÂsÄý shunze ªººô¯¸ MSN : shunze@gmail.com
  « ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD »
µoªí·s¥DÃD µoªí¦^ÂÐ
¸õ¨ì:

Powered by: Burning Board 1.1.1 2001 WoltLab GbR