|
¥DÃD ÃöÁp³sµ²¯¸ ¾\Äý«Ç |
|
¡@ ¡@ 2012/5/25 AM 11:39:48 ¡@ |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
¤½¤åºÞ²z¨t²Î 312.97565(162) ¡@ |
¡@ | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
¤½¤åºÞ²z¨t²Î 1SQL Server 2008ª©ªº¯S¦â¡G 1.¥þ±§ó·s®Ñ¤¤ªº¹ê§@½d¨Ò»P¾Þ§@µe±¡AÅýŪªÌ¥i¥H¸ò¤W¬ì§Þªº¸}¨B¡A¨Ã»P·~¬É±µy¡A¾Ç·|¾Þ§@Microsoft³Ì·sªº¸ê®Æ®wºÞ²z¨t²ÎSQL Server 2008¡C 2.¦b¶}µo¸ê®Æ®wºô¶µ{¦¡ªº³¡¥÷¡X²Ä¤Q³¹¡A±N¨Ï¥Î¤u¨ãPHP¤É¯Å¦Ü³Ì·sª©¥»PHP 5.3¡A¬G©Ò¦³ªºÀô¹Ò³]©wµe±¡B¬ÛÃöÀ³¥Îµ{¦¡§¡¥þ±§ó·s¡B§ï¼g¡C¬°¤F¼W±j¦¹ºô¶..... ¥»®Ñ±N¸ê®Æ®w¨t²Îªº²z½×°µ³Ì§¹¾ãªºÄÄz¡A¨Ã¥HMicrosoft SQL Server 2008°µ¬°¹ê°Èºt½mªºÀô¹Ò¡AÅýŪªÌ¹ï©ó¸ê®Æ®wªº·§©À¯à°÷¿Ä·|³e³q¡C¤º®e¤À¬°°ò¦½g»P¶i¶¥½g¨â¤j³¡¥÷¡G°ò¦½g¥Dn¬O¤¶²ÐÃöÁp¦¡¸ê®Æ®w¨t²Îªº°ò¦²z½×»P¹ê§@¡F¶i¶¥½g«h²[»\¤F²§°ÊºÞ²z¾÷¨î¡Bª«¥ó¾É¦V¦¡¸ê®Æ®w¡B¤À´²¦¡¸ê®Æ®w¨t²Î¡B²§½è©Ê¤À´²¦¡¸ê®Æ®w¨t²Î¡A¥H¤Î°Ó·~´¼¼z»P¸ê®ÆÜÀxµ¥½ÒÃD¡CÂ×´I²Ï¹êªº¤º..... ¥»®Ñ¯S¦â ¡½ ·L³n©x¤è¥Xª©ªº±M·~»{ÃҾDz߫ü«n¡C ¡½ ´£¨ÑӮ׬ã°Q¡B¹ê¾Ôºt½m¡A»P³Ì¨Î¹ê°È¡C ¡½ 200+¹D¼ÒÀÀ¸ÕÃD»P½Æ²ßÃD¡C ¡½ ¦Ûq´úÅç¿ï¶µ¡A¨Ã¥i®Ú¾Úµ²ªG´£¨Ñ¾Ç²ßpµe¡C ³o¤£¶È¬O¤@¥»¥Ñ·L³n©x¤è¥Xª©ªº±M·~»{ÃÒ«ü«n¡A¨ä·N¸q»·³Ó©ó¦¹¡A¨t¦Cªº½Òµ{³]p¤Î¯u¹êӮסA±NÀu¤Æ±zªº¸ê®Æ®w±Mªø¡A¨Ã°µ¦n¥R¤À·Ç³Æ¡A¦b³Ìµu®É¶¡¤º³q¹LMCTS»{ÃÒ¦Ò¸Õ¡C ¡½ ¦w¸Ë..... ¡D ±´°Q¦p¦ó¨Ï¥Î¬d¸ß³Ì¨Î¤Æ¤u¨ã¨îq¬d¸ßpµe¡A¥HÀ°§U±z¼¶¼g¥X§ó¦nªº¬d¸ß¡B¿ï¥Î¸û¨Îªº¯Á¤Þ¡B¨Ã§ä¥X¼vÅT®Ä¯àªº¼ç¦b°ÝÃD¡C ¡D ±´°QSQL Server 2005ªºSSMS»P¯Â¤å¦r«¬ºA¬d¸ß¤ÀªR¤u¨ã¡A¾Ç²ß¦p¦ó¤ÀªR»PÁA¸Ñ¬d¸ß°õ¦æªº±¡ªp¡C ¡D ¸Ô²Ó±´°QÂê©w»P¨ä¹ï¥æ©ö©M®Ä¯àªº¼vÅT¡A¾Ç²ß¦p¦ó¦b¬d¸ß¤¤«ü©wÂê©w·t¥Ü¨ÓÂмgSQL Server¹w³]ªºÂê©w¦æ¬°¡C ¡D ..... ¥Î²`¤J²L¥Xªº¤è¦¡¤¶²Ð¸ê®Æ®w³]pªº²z½×¡A¥]¬A¥¿³W¤Æ»PÓÅéÃö«Y¸ê®Æ¼Ò«¬¡A¨Ã»²¥H¦hÓ¹ê°È¤Wªº½d¨Ò¸Ô²Ó»¡©ú¡C ¸Ô²Ó»¡©úSQL Server 2005¸ê®Æ®wªº¦U¶µ¥\¯à»P¾Þ§@¡C ¸Ô²Ó»¡©ú¨Ï¥ÎSQL Server 2005«Ø¥ß¡BºÞ²z¸ê®Æ®w¥H¤Î«Ø¥ß¡BºÞ²z¸ê®Æªí¡C ¸Ô²Ó¤¶²Ð¸ê®Æ«¬§O»P¨Ï¥ÎÃöÁp¦¡¸ê®Æ®w¬d¸ß»y¨¥T-SQL¶i¦æ¸ê®Æªº¬d¸ß¡B·s¼W¡B§ó·s¡B§R°£¡C ¸Ô²Ó»¡©ú¼¶¼gT-SQLµ{..... ¡½ §¹¾ã²[»\¥ø·~¸ê®Æ®wºÞ²z³Ì¸g¨å¥B¹ê¥Îªº½ÒÃD¡C ¡½ Âǥѧ@ªÌ¦h¦~ªºÅU°Ý¸gÅç¡A©w¸q¡B§ä´M»P¸Ñ¨M®Ä¯à½Õ®Õ¤§ºÃ°Ý¡C ¡½ ²`¤J±´¨sSQL Serverªº¹B§@ì²z¡A¦p¯Á¤Þ¡B´å¼Ð¡B¸ê®Æ¦s¨ú¤¶±¡B¥æ©ö»PÂê©wµ¥¡C ¡½ À˵ø»P¼ÒÀÀSQL Server»P®Ä¯à¬ÛÃö¤§Ä³ÃD¡A¯}¸ÑDBA¤é±`©Ò±Á{ªº°ÝÃD¡A¨Ã´£¨Ñ³Ì¾A¤è®×¡C ¡½ ¸Ô¸Ñ¨t²Î³]pÀ³ª`·N¤§¨Æ¶µ¡Aµ{¦¡¼¶¼g¤§«ØÄ³¡A¦P..... ²{¦bªºªÀ·|¸Ì¡A¸ê®Æ´N¬O¤O¶q¡F¦ý³q¦V¦¨¥\·µ°óªº¯u¥¿¯µ±K¡A¨ä¹ê¦b©ó¦³¯à¤O´x±±§Aªº¸ê®Æ¡C¡mSQL ²`¤J²L¥X¡n±a»âŪªÌª½±´SQL»y¨¥ªº®Ö¤ß¡A±q¨Ï¥Î INSERT »PSELECT ªº°ò¦¬d¸ß»yªk¡A¤@¸ôÁ¿¨ì¨Ï¥Î¤l¬d¸ß¡BÁpµ²¡B¥æ©öªºµw©³¤l¸ê®Æ®w¾Þ§@¡C¾\²¦¥»®Ñ¡AŪªÌ±N¤£¥uÁA¸Ñ¦³®ÄªG¤S¦³®Ä²vªº¸ê®Æ®w«Ø³]¤è¦¡¡A§ó¯à¨ã¦³±M®a¯Åªº¬d¸ß¡B¥¿³W¤Æ»PÁpµ²¾Þ§@¤ô·Ç¡C¦Ó¥B¤]±N¦¨¬°¤âÃä¸ê®ÆªººÞ..... ¥»®Ñ¯S¦â ±z±NÀò±o²Õ«Ø»PºûÅ@¤j«¬¸ê®Æ®w¤è±ªº±M®a¨£¸Ñ ²`¤J±´¨s SQL Server Àx¦s¤ÞÀºªº¤º³¡µ²ºc¡A¥H¤Î§@ªÌ»P SQL Server ±M®aªº«ØÄ³¡C¸ê®Æ®w¶}µoªÌ»PºÞ²zû¥i¥H±o¨ì³Ì¨Îªº¹ê°È¡A¨ãÅ骺«ØÄ³¡A¥H¤Îµ{¦¡¼Ë¥»¡A¨ó§U´x´¤«Ø¥ß»PºûÅ@¥ø·~¯ÅÃöÁp¦¡¸ê®Æ®wªººëÅè¡C ¥»®Ñ¤º®e«ÂI¡G ¡D¤É¯Å©ÎÂà´«¬° SQL Server 2005¡A¨Ã¿ï¾Ü²ÕºA¿ï¶µ¡C ¡D¤â¤u©Î¦Û..... ³o¤£¶È¬O¤@¥»¥Ñ·L³n©x¤è¥Xª©ªº±M·~»{ÃÒ«ü«n¡A¨ä·N¸q»·³Ó©ó¦¹¡A¨t¦Cªº½Òµ{³]p¤Î¯u¹êӮסA±NÀu¤Æ±zªº¸ê®Æ®w±Mªø¡A¨Ã°µ¦n¥R¤À·Ç³Æ¡A¦b³Ìµu®É¶¡¤º³q¹LMCITP»{ÃÒ¦Ò¸Õ¡C Âǥѥ»®Ñ¾Ç²ß¡A±z±N¦b»{ÃÒ¦Ò¸Õ¦³¦p¤Uªº¨ô¶Vªí²{¡G ¡D¬d¸ß¸ê®Æ®w»P¦øªA¾¹ªººÊ±±»P¿ù»~³B²z¡C ¡DºÞ²z¦w¥þ©Êµ¦²¤»P°õ¦æªººÊµø¡C ¡D¨ó§U¨¾¿mÁô½X§ðÀ»¡Bªýµ´ªA°È§ðÀ»¡B¤ì°¨»P¯f¬r¡C ¡D°»´ú»P¸Ñ¨M¸ê®Æ½Ä¬ð¡C ..... ¹ï©ó¨C¤Ñ¥²¶·±µÄ²T-SQL¡A¦ý«o±`±`¹J¨ì«È¤án¨D¤£ª¾¸Ó¦p¦ó¸Ñ¨M¡B©Î¬O¬d¸ßªºµ²ªG»P¦Û¤v·Qªº¤Ñ®t¦a»·ªºMIS/DBA/µ{¦¡¶}µo¤Hû¡A¥»®Ñ´£¨Ñ¼Æ¶qÁc¦hªº±`¨£°ÝÃD»P¸Ñµª¡A¨Ã¥B¥H°ÝÃD¡]¥Øªº¡^¬°¾É¦V¡A®e©ö¬d¾\¡A¥®Éºt½m¡BÁ{³õ¸Ñ¨M°ÝÃD»P°Ñ¦Ò»ùÈݨã¡C ¥»®Ñ¯S¦â ¡¼ °ÝÃD¾É¦V¡G¶W¹L400Ó°ÝÃD¸Ñ¨M¤è®× ¡¼ ÝÅU¾Ç²ß¡G¥®É¥i½m²ßºë¶i¡BÁ{³õ¥i¸Ñ¨M°ÝÃD ¡¼ ®e©ö¬d¾\¡G..... ¥»®Ñ¯S¦â §¹¾ã»¡©ú¸ê®Æ®w³]p»P¶}µo¤HûÀ³¨ã³Æªº²z½×¡BÆ[©À©M§Þ¯à¡AÀ°§U§Aºë³qSQL ServerªºTransact-SQLµ{¦¡³]p ¡D¥»®Ñ¬O¥H¸ê®Æ®w³]p»P¶}µo¤Hû¨¤«×¨Ó¤Á¤JSQL Server¸ê®Æ®wµ{¦¡³]p»P¶}µo¡A¦b¤º®e¤W¡A§¹¾ã»¡©ú¸ê®Æ®w¨t²Î¬ÛÃö²z½×¡B ¸ê®Æ®w³]p²z½×»PT-SQLµ{¦¡³]p¡A¯à°÷°V½m©M´£ª@ŪªÌ¾Ö¦³¨¬°÷ªº§Þ³N¯à¤O¨Ó¦Û¦æ³]p»P«Ø¥ßSQL S..... ¥»®Ñ¤À¦¨¤T¤j³¡¤À¡A²Ä¤@³¡¥÷¬O¤¶²ÐÃöÁp¦¡¸ê®Æ®wªº·§©À»P°ò¥»Transact-SQL¡AT-SQL»yªk¡A¥]¬A¸ê®Æ©w¸q»y¨¥(DDL)¡B¸ê®Æ±±¨î»y¨¥(DCL)¡B¸ê®Æ¾Þ§@»y¨¥(DML)¡B¬yµ{±±¨î»y¨¥»P°ò¥»ª«¥ó¨Ï¥Îµ¥¡A¸Ó³¡¤À¬O¾A¦Xªì¾ÇªÌ¾Ç²ßSQL Server 2005»y¨¥ªº°_¶]ÂI¡F²Ä¤G³¡¤À¡A¬OÂǥѹê»Ú®×¨Ò¤¶²ÐTransact-SQL»yªkªº¶i¶¥¨Ï¥Î§Þ¥©¡A¥]¬AÀ˵ø¡B¨t²Î¥Ø¿ý..... ¥»®Ñ¤º®e¥Ñ²L¤J²`¡A¥ý¤¶²Ð¸ê®Æ®wªºÆ[©À¡AÅýŪªÌ¹ï¸ê®Æ®w¦³Ó°ò¥»ªº»{ÃÑ¡A±µµÛ¾É¤JSQL Server2005»¡©ú¦p¦ó«Ø¥ß¸ê®Æ®w¡A¶i¦Ó§Q¥ÎSQL«ü¥O¨Ó¬d¸ß»PºûÅ@¸ê®Æ®wªº¸ê®Æ¡C¨Ã¥B²`¤J¤¶²ÐT-SQL»yªk¡B¹w¦sµ{§Ç¡B¦Ûq¨ç¼Æ¡BIJµoµ{§Ç¡B¥æ©öµ¥¥DÃD¡A±Ð¾ÉŪªÌ¦p¦óºÞ²z³]pÀ³¥Îµ{¦¡¤¤¸ê®Æ®wºÝªºµ{¦¡¡A³Ì«á¦A¥H¹ê»ÚªºÀ³¥Îµ{¦¡½d¨Ò¨Ó¤¶²Ð¥HSQL Server¬°¸ê®Æ®w¨t²ÎªºÀ³¥Îµ{¦¡..... SQL Server¬OÃöÁp¦¡¸ê®Æ®w¡A¬°¥Ø«e¸ê®Æ®wªº¥D¬y¤§¤@¡AYn¦³®Ä²vªº±±¨î¸ê®Æ®w¨t²Î¡ASQL»y¨¥´N¬O±±¨î¸ê®Æ®w¨t²Î«nªº¤è¦V²ë¡A¦b¥»®Ñ¤¤¸Ô²Ó±´°Q¤F¸ê®Æ®w³nÅé©MµwÅ骺¾ã¦X¹B§@¡A¨Ã¥H³Ì»´ÃP©M¦³®Ä²vªº¤è¦¡¨Ó»¡©ú©M¾Þ§@SQL Server¸ê®Æ®wºÞ²z¨t²Î¡A³Ì«á¥HÅçÃÒµ²ªGªº¹ê»Ú½d¨Ò¨Ó¾É¤JSQL Server 2005»P¦UºØÀ³¥Îµ{¦¡ªº¹B¥Î¡C ¥»®Ñ¯S¦â ¥HSQL Serv..... ¥»®Ñ¯S¦â ¡½¥»®Ñ¬O¥H¸ê®Æ®wºÞ²z®vDBA¨¤«×¨Ó¤Á¤JSQL Server¸ê®Æ®wºÞ²zªº¥DÃD¡A¦b¤º®e¤W¡A§¹¾ã»¡©ú¸ê®Æ®wt²Î¬ÛÃö²z½×»PºÞ²z§Þ¯à¡A¯à°÷°V½m©M´£ª@ŪªÌ¾Ö¦³¨¬°÷ªº§Þ³N¯à¤O¨Ó¦¨¬°¤@¦ìSQL Server¸ê®Æ®wºÞ²z®v¡C ¡½¦b¹ê§@¤W¡A¥»®Ñ¬O·f°t·L³nSQL Server 2005¤¤¤å¥ø·~ª©¡A³o¬O¤@¥»¯u¥¿´À¦³§Ó¦¨¬°¸ê®Æ®wºÞ²z®vªºÅªªÌ¡B©Î¾Ç®Õ¸ê®Æ®wºÞ²z½Òµ{©Ò³W¹ºªººÞ²z¹ê..... ¦p¦Pºt«µ©M©¶¯ë¡A¥»®Ñ±q³øªí·§½×¡B³øªí³]p¡B³øªíºÞ²z¡Aª½¨ì³øªí¶}µo¡Aºc¦¨§¹¾ãªº³øªí¥Í©R¶g´Á¯ßµ¸¡A¥H¹ê°È®×¨ÒÅçÃÒReporting Servicesªº«Ø¸m¬yµ{¡A¨Ã»EµJ©ó¾É¤Jªº«ÂI¡Cºëªö¤º®e¥]¬A¡G ¡½ »¡©ú³øªíªA°È¦b°Ó·~´¼¼z¤¤ªº¨¤¦â¤Î³øªí¥Í©R¶g´Á¡A¤¶²Ð³øªí¦øªA¾¹ªº¬[ºc»P¦U¶µ¤¸¥ó¡A¥H¤ÎReporting Services¦w¸Ë¬yµ{¡A¤Î³øªí¦øªA¾¹ªº³]©w¡C ¡½ ³z¹LR..... ¥»®Ñ¬°¾ã¦X²z½×»P¹ê°Èªº¸ê®Æ®w¨t²Î±Ð§÷¡A¦b¬[ºc¤W±N¥»®Ñ¤À¬°¤¤j³¡¤À¡A³o¤¤j³¡¤ÀÂI¥X¤F¾Ç²ß¸ê®Æ®w¨t²ÎªººëÅè¡A¨Ã³z¹L¨CÓ³¹¸`¤§¶¡ÃöÁp©Êªº¤Þ¾É¡A¥H´Á¦¬¨ì¨ã¦³¾ãÅé§»Æ[·§©À¤§®ÄªG¡C ¬°¤FÅýŪªÌ¥i¥H¦b³Ìµuªº®É¶¡¤º¨ã¦³¹ê°È»P²z½×ªº¯à¤O¡A¥»®Ñ§@ªÌ¥H¨ä¦h¦~±Ð¾Ç»P¹ê°È¸gÅç¡A³z¹Lºë¤ß³]pªº½d¨Ò³v¤@ÅçÃÒ¸ê®Æ®w²z½×¡AÅýŪªÌ¦b¾Ç²ß¹Lµ{¤¤¹F¨ì¹ê°È»P²z½×¬Û»²¬Û¦¨ªº¥Øªº¡C ¦¹¥~¡A¬°¤FÅý..... ¥»®ÑÂ^¨ú¤F¥ø·~¦b¶i¦æ¨t²Î¶}µo»PºûÅ@ºÞ²z®É¡A³Ì¹ê¥Î¥B³Ì¸g¨åªº¥DÃD¡A¥]¬A¡G ¡½ ¼ô¸ZÃöÁp¦¡¸ê®Æ®w·§©À¡BSQLµ{¦¡»y¨¥·§½×¤Î¬ÛÃö¶}µo¤u¨ã¡C ¡½ ²`¤J°Q½×DML»yªk¡A°ò¦«o¤]¦Ü¬°ÃöÁä«n¡C ¡½ ¨Ï¥ÎDDL»yªk¼¶¼gSQL Server¦øªA¾¹ºÝª«¥ó¡A¨ä¤¤º«¸ê®Æªí¡C¦P®É¡A¬°´£¤É¸ê®Æ®wºÞ²z»P¨Ï¥Îªº¦w¥þ©M¼u©Ê¡A¶i¤@¨B¥HDDL»yªk¬°©³¡A»²¥H¦UºØ¦øªA¾¹ºÝª«¥óªº¥\¯à¡A¸ÑªRÀË.....
¤½¤åºÞ²z¨t²Î 2³o¤£¶È¬O¤@¥»¥Ñ·L³n©x¤è¥Xª©ªº±M·~»{ÃÒ«ü«n¡A¨ä·N¸q»·³Ó©ó¦¹¡A¨t¦Cªº½Òµ{³]p¤Î¯u¹êӮסA±NÀu¤Æ±zªº¸ê®Æ®w±Mªø¡A¨Ã°µ¦n¥R¤À·Ç³Æ¡A¦b³Ìµu®É¶¡¤º³q¹LMCITP»{ÃÒ¦Ò¸Õ¡C Âǥѥ»®Ñ¾Ç²ß¡A±z±N¦b»{ÃÒ¦Ò¸Õ¦³¦p¤Uªº¨ô¶Vªí²{¡G ¡½ ¾Ç²ß»P¦Ò¸Õª½±µ¬ÛÃöªº¥DÃD¡C ¡½ ¦w¸Ë¡B²Î¦X»P²ÕºA¦hÓ¸ê®Æ®w°õ¦æÓÅé¡C ¡½ °w¹ï¹êÅé¸ê®Æ®w³]p¸ê®Æªí¡BÀɮ׸s²Õ»P¯Á¤Þ¡C ¡½ ¦b¦øªA¾¹¡B¸ê®Æ®w..... ¹ï©óºÞ²z¤½¥q¸ê®Æ®w»P¶}µo¨t²Îªº MIS/DBA/Developer ¤Hû¨Ó»¡¡A±¹ï¤½¥q¦h¼Ëªº³øªí»Ý¨D¡A¦pªG¥u·|¤@¯ë SQL Server ®ÑÄy¤¤³æ¤@³¹¸`©Ò±ÐªºÂ²©ö³øªí¬O¤£°÷ªº¡A¡mSQL Server 2005 Reporting Services ¹ý©³¸Ñ»¡¡n´N¬O±M¬°±z©Ò¼¶¼g¡A¤£½×¬O»s§@³øªí¡BºÞ²z³øªí¡B»PÀ³¥Îµ{¦¡¾ã¦X¡A²Î²Î³£¦³¸Ô²Ó§¹¾ãªº¸Ñ»¡¡C ¥»®Ñ¯S¦â¡G ¡¼..... ³o¤£¶È¬O¤@¥»¥Ñ·L³n©x¤è¥Xª©ªº±M·~»{ÃÒ«ü«n¡A¨ä·N¸q»·³Ó©ó¦¹¡A¨ä¤@¨t¦Cªº½Òµ{³]p¤Î¯u¹êӮסA±NÀu¤Æ±zªº¸ê®Æ®w±Mªø¡A¨Ã°µ¦n¥R¤À·Ç³Æ¡A¦b³Ìµu®É¶¡¤º³q¹LMCTS»{ÃÒ¦Ò¸Õ¡C Âǥѥ»®Ñ¾Ç²ß¡A±z±N¦b»{ÃÒ¦Ò¸Õ¦³¦p¤Uªº¨ô¶Vªí²{¡G ¦w¸Ë»P³]©wSQL Server 2005 «Ø¥ß¸ê®Æªí»P¯Á¤Þ¡B©w¸qÄæ¦ì¡A¨Ã¹ê§@¨î±ø¥ó ¨Ï¥ÎTransact-SQL¹ê§@¨ç¼Æ¡B¹w¦sµ{§Ç»PIJµo¾¹ ³B²z..... ¥»®ÑµÛ«©ó°ò¥»ªºSQL Server 2005¨t²ÎºÞ²z¾Þ§@¡A±qåªRÅé¨tµ²ºcªºÆ[ÂI¨Ó¤ñ¸û²`¤J¦a¬ã¨sºÞ²zSQL Server 2005ªºÃÀ³N¡A±qì²z¤WÁ¿¸ÑSQL Server 2005ªº¤u§@¾÷¨î¡C¦P®ÉÁÙ·|¥]¬ASQL Server 2005ªº°ª¯ÅºÞ²z¤º®e¡A¤ñ¦p°O¿ýÀɪººÞ²z¡B½Æ»s¡B¸ê®Æ¾ã¦XªA°È¡B¥N²zªA°È¡BDBCCºÞ²z©R¥Oµ¥¡A¾A¦XSQL Server 2005ªì¾Ç¤Îªì..... ¡D SSIS·§Æ[¡G¥H½d¨Ò¤¶²ÐSSIS³]p®v¡A§Ö³t«Ø¥ßIntegration Services«Ê¸Ë¡A¨Ã¼ô±x§Y®É©Ê¤¬°Êªº°£¿ùÀô¹Ò¡C ¡D SSIS¹w³]¿W¥ß¥\¯à¡G¥H¤j¶qªº½m²ß³v¤@¤¶²Ð¨äÄݩʤΥΪk¡A¦p±±¨î¬yµ{¡B¸ê®Æ¬yµ{¡A¥H¤Î¨Æ¥ó¬yµ{¥i¥Îªº¤u§@»P¤¸¥ó¡C ¡D ¶i¶¥À³¥Î¡G¤¶²Ð¬[ºc¦w¥þ©Ê¡BWMI¡BXML¤Î®Ä¯à½Õ®Õ¡A¨Ã¥HVB.NET¦s¨úSSISªºª«¥óµ²ºc¨Ó¶}µo¤u§@©M¤¸¥ó¡A©µ..... ÀH®ÑªþÃØ Microsoft SQL Server 2005¤¤¤å 180 ¤Ñµû¦ô¥úºÐ Åý±z¥i¥H¹ê»Ú¦w¸Ë, ¨Ã¨Ì®Ñ¤¤»¡©ú¾Þ§@, ¥[±j²z¸Ñ»PÀ³¥Î¯à¤O¡C ¦U³¹SQL ½d¨Òµ{¦¡¬Ò´£¨ÑŪªÌ©ó³ÕºÓºô¯¸¤U¸ü±M°Ï¡A¤è«KŪªÌª½±µ¾Þ§@¡BÅçÃÒ, ´î¤ÖÁä¤Jµ{¦¡½X©Ò»Ý¯Ó¶Oªº®É¶¡, ´£ª@¾Ç²ß®Ä²v¡C ¥»®Ñ¥Hªì¦¸¾Ç²ß¸ê®Æ®wºÞ²z»PÀ³¥ÎªºÅªªÌ¬°¶D¨D, ¨Ã¥H³Ì·sªº Microsoft SQL..... ¡mSQL Server 2005¸ê®Æ®wºÞ²z¡n¬O¸Ôz·L³n·s¤@¥NÃöÁp¦¡¸ê®Æ®w¨t²Îªº¹ê¾ÔÄ_¨å¡C§@ªÌ¥H¦h¦~Â×´Iªº¸ê®Æ®w¨t²Î«Ø¸m»P¾ã¦X¸gÅç¡A°w¹ï¸ê®Æ®wºÞ²z¤Hû¡A²`¤J²L¥X¦a±´°Q³Ì¹ê¥Îªº¸ê®Æ®wºÞ²z§Þ¥©¡C ¥»®Ñ¯S¦â ¡D¸ê®Æ®w¹B§@ì²z¡G§¹¾ã¤¶²ÐSQL Server¸ê®Æ®wªº¤º³¡µ²ºc»P«Ø¸m§Þ¥©¡A¥i¨ó§U±z³W¹º°ª®Ä¯àªº¸ê®Æ¥æ©öÀô¹Ò¡C ¡D°ª¥i¥Î©Ê¸Ñ¨M¤è®×¡G²`¤J¬ã¨s¸ê®Æ®w³Æ¥÷¡BÁÙì»P½Æ..... ¡D¸ê®ÆÜÀx»POLAP¡G´`§Çº¥¶iªº¤¶²Ð¡A±N¦hºû«×¸ê®ÆÜÀx«Ø¸m»POLAP§Þ³N§¹¾ã§e²{¡C ¡D°ÊºA¦hºû«×¤ÀªR¡GÂÇ¥ÑCubeºëÆF¡A¶i¦Ó¤F¸ÑOLAP¥i¨Ì¸ê®Æ®w¤¤¤£¦Pªººc±¡A¤ÀªR¨äÃöÁp©Ê¡A²£¥Í°ÊºA¥B§Y®Éªº³øªí¡A¤ä´©ºÞ²z¨Mµ¦¡C ¡D½ÆÂøpºâ§Ö³t¬d¸ß¡G³z¹LMDX»yªkÁ¿¸Ñ¡AºÞ²zªÌ¥i¨Ï¥ÎOLAP½u¤W¤ÀªR¼Ò²Õ¡A®Ú¾Ú¤£¦PÅܶµªº¦Ò¶q¡A°õ¦æ¸ê·½°t¸m¤ÎÁͶդÀªRµ¥½ÆÂøpºâ¡C ¡D³zªRÀ³¥Î¼Ò..... ¡D MDX¥þ¤è¦ìåªR¡G°w¹ïAnalysis Services»PMDX¡A¥Ñ¹ê°È±»P¤u¨ã±¤£¦P¨¤«×¤Á¤J¡A¥H¤F¸ÑMDX¦b°Ó·~´¼¼z¬[ºc¤¤ªº«n©Ê¡C ¡D Æ[©À¬°¥D»yªk¬°»²¡G¸Ôz¨CÓMDX¨ç¼Æªº¥Î³~¡A¥H¹ê¨Ò»¡©ú¨Ï¥Î¤è¦¡¡AÀ°§UŪªÌ¹ý©³¾Ç²ß»PÀ³¥Î¡C ¡D ¦Û¦æ¶}µo¦Ûq¨ç¼Æ¡G¦Ûq¨ç¼Æ¥i¤j´T¼W¥[¨ä¼u©Ê»PÂX¥R©Ê¡A¯S§O±´°Q¶}µo¡B°£¿ù¡BKPIÀ³¥Î»PÅv³]©wµ¥¬ÛÃöªº«n½ÒÃD¡C ¡D ..... ¥»®Ñ±q°ò¥»·§©À©M¹ê»ÚÀ³¥Î¥Xµo¡A¥Ñ²L¤J²`´`§ÇÁ¿z¸ê®Æ®w³]p°ò¦ª¾ÃÑ¡A±q¸ê®Æ®w³Ð«Ø¡B¸ê®Æªíªº¾Þ§@¡BÀ˵øªí¾Þ§@¡B¯Á¤Þ³Ð«Ø¡B¹w¦sµ{§Çµ{»PIJµoµ{§ÇÀ³¥Î¡B¸ê®Æªº¦w¥þ»PºÞ²z¡B³Æ¥÷»PÁÙìµ¥¤º®e¡F¨ì¦p¦ó±N¥ø·~²°T¦¬µo¥¥x®×¨Ò¿Ä¤J¦U³¹¸`¡AÄÄz¸ê®Æ®w³Ð«Ø¡BºÞ²z¡B¶}µo»PSQL»y¨¥µ{¦¡³]p¤ßªk¡F²©ú§ãn¦a¤¶²ÐSQL Server¹ê°È¾Þ§@¡AÅý¾Ç²ßªÌ¯à´x´¤¸ê®Æ®wªº°ò¥»ª¾ÃÑ»P§Þ¯à¡C 11°ó..... ¡mSQL¤§¬ü¾Ç¡n¤@®Ñ¡A¬O§@ªÌ Stephane Faroultɥή]¤l§Lªkªº´¼¼z¡A¨Ó³B²zSQL®Ä¯àªº¹Á¸Õ¡C¸ê®Æ®w³]p¬O¾Ô«eªº·Ç³Æ¡Bµ{¦¡³]p¬O¾ãÅé¾Ô²¤¡A¦Ó¨C¤@¦¸¸ê®Æ®w¦s¨ú³£¬O»P¼Äx¦b¾Ô³N¤Wªº¹ï¨M¡C Stephane¬Ý«ÝSQL®Ä¯àªº¤è¦¡¥i¯à¤£¦p±`³W¥B¬Û·í¿W¯S¡A¦ý¥L¥i¬O¬Û·í»{¯u¦a¬Ý«ÝÀu¨qSQLªº³]p¥H¤ÎSQLªºµ½¥Î¡C¦³¤F¡mSQL¤§¬ü¾Ç¡n¡AŪªÌ±N¯à±q¯u¹ê¥Í¬¡ªº°}..... ¥»®Ñ¬O¥HDBA¨¤«×¨Ó±´°Q¦p¦ó¾Ç²ßSQL Server 2005ºÞ²zªº°ò¥»¥\¤Ò»P¶i¶¥¹B¥Î§Þ¥©¡C®Ñ¥»¤º®eÂ×´I±q°ò¥»¦øªA¾¹¡B¸ê®Æ®wªº«Ø¥ßºÞ²z¡B¦w¥þ©Êªº¤¶²Ð¡B¨aÃø´_ì»P724°ª¥i¥Î«×¡B¸ê®Æ²¾Âà»P²§½è¸ê®Æ®w¾ã¦X¡A¶i¶¥ªº¦Û°Ê¤ÆºÞ²z¡B½Æ¼g»P®Ä¯à½Õ®Õ³£¬O¥þ®Ñªº«ÂI¡C¦¹¥~¡A¥»®Ñ¤jÁx¬ð¯}©Ò¦³®Ñ¥»ªº¨î¡A¥i¥H¥]¬A¼s¤jSQL Server 7.0/2000ªº¥Î¤á¡A³z¹L¤º®e¤¶²Ð¥i¥HÅý..... ³]p¤@Ó¦nªº¸ê®Æ®w¨t²Î¤£¶È»Ýn²`«pªº²z½×I´º¤ä«ù¡AÁÙ»Ýn»P¹ê°È¬Ûµ²¦X¤è¯à¬Û»²¬Û¦¨¡C¥»®Ñ¤º®e¥Ñ²L¤J²`¡A±´°Q¤º®e²[»\¸ê®Æ®w°ò¦²z½×¤¶²Ð¡B¤ÀªR©M³]p¸ê®Æ®w¨t²Î¡BSQL Server 2005 ¸ê®Æ®w³]p¹ê°Èµ¥¡A«D±`¾A¦X²Ä¤@¦¸±µÄ²¸ê®Æ®wªºÅªªÌ¡A§ó¥[¾A¦X·í¦¨¤j±M°|®Õ¶}³]¸ê®Æ®w¬ÛÃö½Òµ{ªº±Ð¬ì®Ñ¡C ¥»®Ñ¯S¦â ¤°»ò¬O¸ê®Æ®w¡G·|¨Ï¥Î¸ê®Æ®w¡A¦ý¤£¤@©w¥Nªí¼ô±x¸ê®Æ®wªºì²z¡AÂǥѥ»..... ¨Ï¥Î¤Fªñ600Ó«ü¥OÀÉ¡].sql¡^»P¼ÆÓWindowsÀ³¥Îµ{¦¡¤ÎÃþ§O®w±M®×¡A¸Ô¹ê¥B²`¤J±´°QSQL Server 2005ªº¸ê®Æ®w«Ø¸m¡BTransact-SQLµ{¦¡³]p»PXMLµ¥¤T¤j®Ö¤ß»â°ì¡A¥´¤U¤£¥i°Ê·nªº®Ú°ò¡C ±z·Qn´£ª@¦Û¤vªºSQL Server 2005¹ê¤O¶Ü¡A½Ð±q²{¦b¶}©l¡F±z·Qn´£ª@¦Û¤vªºSQL Server 2005¥\¤O¶Ü¡A½Ð±q¥»®Ñ¶}©l¡C ..... ¥»®Ñ§¹¾ã¦³¨t²Îªº¤¶²Ð¤F¸ê®ÆÜÀx»P¸ê®Æ±Ä±¸ªºì²z¡B¶}µo»PÀ³¥Î§Þ³N¡C ¤º®e¤Á¤J±q¹ê°Èªº¥þ¤è¦ì¨¤«×¥Xµo¡A´¦¶}¸ê®ÆÜÀx¡B½u¤W¤ÀªR³B²z(OLAP)»P¸ê®Æ±Ä±¸¤W±À³¥Î¶ø¯µ¡C ¤º®eµÛ«¤G¤Q¤@¥@¬öª¾ÃÑ«¬ªÀ·|³Ì¬y¦æªººô¸ô((Web)¸ê®Æ±Ä±¸»P¦h´CÅé¸ê®Æ±Ä±¸§Þ³N¤Î·L³nSQL Server 2005 ¸ê®ÆÜÀx¤u ¨ã¡A»P·L³nSQL Server 2005¸ê®Æ±Ä±¸§Þ³N ..... ¥»®Ñ¦@¤À¬°¤W¤U¨â½g¡A¤W½g¬°²z½×»P§Þ³N½g¡A¤¶²Ð¤F¸ê®ÆÜÀx»POLAP·§©À¡Bì²z»P§Þ³N¡A¤U½g¬°³nÅé¤u¨ã»P¹ê¨Ò½g¡A¤¶²Ð¤F¸ê®ÆÜÀx³nÅé¤u¨ã¡A¦æ°Ê³q°TªA°È¸ê®ÆÜÀx¨t²Î¡A¤Î¶q³c©±¸ê®ÆÜÀx³Wµe¡B³]p»P°õ¦æ¹ê¨Ò¡A¨Ã¦b¨ä¤¤¬ï´¡¤¶²Ð¤FSQL Server¦b¸ê®ÆÜÀx¶}µo¤¤ªºÀ³¥Î¹ê°È¡A¨ä¥Øªº¦b©ó¨ÏŪªÌ¯à°÷§ó²`¤J¦a¤F¸Ñ¸ê®ÆÜÀx¡BOLAPªº¨ÓÀs¥h¯ß¡C ¥»®Ñ¹ï¸ê®ÆÜÀx¡BOLAPªºì²z¡B..... ¥»®Ñ±q°ò¥»ªºµ{¦¡¶}µo©Ò»ÝnªºT-SQL¶}©l¤¶²Ð¡A¥]¬AXML¡BWebªA°È¡B¾ã¦X.NET¶}µoSQLCLRª«¥ó¡BService Broker¡B³qª¾ªA°È¡B¹w¦sµ{§Ç»P¨Ï¥ÎªÌ¦Ûq¨ç¼Æ¡BIJµoµ{§Ç¨ì³Ì«áªº¥æ©öÂê©w³B²z»P¦h°ê»y¨t¨Ï¥Îµ¥½Ñ¦h¥\¯à¡AÅn¬A©Ò¦³µ{¦¡¶}µo¤Hû¥²³Æªº¸ê®Æ®w¾ã¦X«eºÝµ{¦¡¶}µoªº¥\¤Ò¡C¨C¤@³¹¸`³£·|¥ý³¯z¦U¸ê®Æ®w¥\¯àªº¨Ï¥Î±¡¹Ò»Pª`·N¨Æ¶µ¡A¦A·f°tVisual Stu..... ¥»®Ñ¸Ô²Ó¤¶²Ð SQL Server 2005 ªº¦U¶µºÞ²z¥\¯à, ¥]§t¦w¥þºÞ²z¡B³Æ¥÷/¦^¦s¡B®Ä¯à½Õ®Ä¡B½ÆÂø¤u§@¦Û°Ê¤Æªº¤è¦¡...µ¥¡C°£¤F»¡©ú¥þ·s SQL Server Management Studio ¤Î Business Intelligence Development Studio ¹Ï§ÎºÞ²z¤u¨ãªº¾Þ§@¤è¦¡¥~, ¤]·|´£¨Ñ¥H T-SQL ©M¨t²Î¹w¦sµ{§Ç¨Ó§¹¦¨.....
¤½¤åºÞ²z¨t²Î 3¥»®Ñ¤¶²Ð¸ê®ÆÜÀx¨t²Îªº²z½×¤Î¬ÛÃö§Þ³N¡A¥H¥©öªñ¤H¥B¥Í¬¡¤Æªº¤è¦¡¡A¤¶²Ð¥]¬A¸ê®Æ¼Ò¦¡¡BSQL¥Îªk¡B¨t²Î®Ä²v½Õ¾ã¡B¸ê®ÆÜÀxÀ³¥Î¤u¨ã¡A¥H¤Î¸ê®Æ±´°Éµ¥¬ÛÃöijÃD¡C¥R¤À¹B¥Î¦UºØ¹ê¥Î½d¨Ò¡A²`¤J²L¥X¸Ñ»¡»P§Y®ÉÀ³ÃҩҾǡA§@ªÌ¥H¦Û¨ªº¹ê¾Ô¸gÅç¥H¤Î«ÈÆ[ªº¨¤«×½s¼g¥»®Ñ¡A´£¨ÑŪªÌªº¹ê¥Î¸ê°T¡A¨Ã«Øºc§¹¾ã¸ê®ÆÜÀx·§©À¡C ¥»®Ñ¯S¦â ²LÅã©öÀ´¡G´¬°£³\¦hÃøÀ´ªº±M¦³¦Wµü¡A¤Î½ÆÂøªº¤½¦¡¡A¥H°ò¦¦ý..... ¥»®Ñ±q°ò¥»ªºµ{¦¡¶}µo©Ò»ÝnªºT-SQL¶}©l¤¶²Ð¡A¥]¬AXML¡BWebªA°È¡B¾ã¦X.NET¶}µoSQLCLRª«¥ó¡BService Broker¡B³qª¾ªA°È¡B¹w¦sµ{§Ç»P¨Ï¥ÎªÌ¦Ûq¨ç¼Æ¡BIJµoµ{§Ç¨ì³Ì«áªº¥æ©öÂê©w³B²z»P¦h°ê»y¨t¨Ï¥Îµ¥½Ñ¦h¥\¯à¡AÅn¬A©Ò¦³µ{¦¡¶}µo¤Hû¥²³Æªº¸ê®Æ®w¾ã¦X«eºÝµ{¦¡¶}µoªº¥\¤Ò¡C¨C¤@³¹¸`³£·|¥ý³¯z¦U¸ê®Æ®w¥\¯àªº¨Ï¥Î±¡¹Ò»Pª`·N¨Æ¶µ¡A¦A·f°tVisual Stu..... ³øªí¦b¸ê°T¨t²Î¤¤¦û¦³¤FÁ|¨¬»´«ªº¦a¦ì¡C ¦]¬°¥¦ªÓtµÛ¶Ç»¼°ò¥»¸ê°T¡B³¡ªù·¾³qªº¨¤¦â¡AY«Ü®e©ö±q¸ê®Æ¨Ó·½´£¨ú¸ê®Æ¡AÀò±o»²§U¨M©wªº³øªí¡A±N¥i´£¤É¾ãÅ饸·~ªº´¼¼z¡A¦bÄvª§ªº°Ó·~Àô¹Ò¤¤«O¦³Ävª§¤O¡C Reporting Services 2005 ¦b¾ãÅ骺¥\¯à¤W¡A·s¼W¤F§ó¦h¤Íµ½ªº¤¬°Ê¤¶±¡AÂX¥RºÞ²z»P¶}µoªº¥\¯à¡C ¦]¦¹¡A¤£½×¬Oµ{¦¡³]p®v©Î¨Ï¥ÎªÌ¡A¦b¶}µo©Î¨Ï¥Î³øªí..... ¥Î¹ê§@ªº¤è¦¡¤¶²ÐSQL Serverªº¾Þ§@¤¶±¥H¤Î¸ê®Æ®wªº«Ø¸m»P°ßÅ@¡A¥iÅý¤£´¿±µÄ²¹LSQL Server©Î¸ê®Æ®w³nÅ骺ŪªÌ¡A»´©ö¤W¤â¨Ã¦³®Ä¦aºÞ²z¸ê®Æ®w¡C ¥Î´`§Çº¥¶iªº¤è¦¡¤¶²ÐSQL«ü¥O¡A±q¸ê®Æ®wºÞ²z¡B¸ê®Æªí³]p¡A°O¿ý¼W§R»P½Æ»s¡B©µ¦ù¨ì¶i¶¥ªº¬d¸ß»P¥þ¤åÀ˯Á¡A¨Ã°w¹ïCTE¡B±Æ§Ç¨ç¼Æµ¥·s¼Wªº¥\¯à´£¨Ñ§¹¾ãªº»¡©ú¡A¥iÅýŪªÌ¤Jªù¶i¶¥¤@¦¸¾Ç»ô¡C ¹ý©³åªRT-SQL..... ¥»®Ñ¸Ô²Ó¤¶²Ð SQL Server 2005 ªº¦U¶µºÞ²z¥\¯à, ¥]§t¦w¥þºÞ²z¡B³Æ¥÷/¦^¦s¡B®Ä¯à½Õ®Ä¡B½ÆÂø¤u§@¦Û°Ê¤Æªº¤è¦¡...µ¥¡C°£¤F»¡©ú¥þ·s SQL Server Management Studio ¤Î Business Intelligence Development Studio ¹Ï§ÎºÞ²z¤u¨ãªº¾Þ§@¤è¦¡¥~, ¤]·|´£¨Ñ¥H T-SQL ©M¨t²Î¹w¦sµ{§Ç¨Ó§¹¦¨..... ³øªí¦b¸ê°T¨t²Î¤¤¦û¦³¤FÁ|¨¬»´«ªº¦a¦ì¡C ¦]¬°¥¦ªÓtµÛ¶Ç»¼°ò¥»¸ê°T¡B³¡ªù·¾³qªº¨¤¦â¡AY«Ü®e©ö±q¸ê®Æ¨Ó·½´£¨ú¸ê®Æ¡AÀò±o»²§U¨M©wªº³øªí¡A±N¥i´£¤É¾ãÅ饸·~ªº´¼¼z¡A¦bÄvª§ªº°Ó·~Àô¹Ò¤¤«O¦³Ävª§¤O¡C Reporting Services 2005 ¦b¾ãÅ骺¥\¯à¤W¡A·s¼W¤F§ó¦h¤Íµ½ªº¤¬°Ê¤¶±¡AÂX¥RºÞ²z»P¶}µoªº¥\¯à¡C ¦]¦¹¡A¤£½×¬Oµ{¦¡³]p®v©Î¨Ï¥ÎªÌ¡A¦b¶}µo©Î¨Ï¥Î³øªí..... ªñ¦~¨Ó¬F©²P¤O±À°ÊM-Taiwanpµe¡A¨Ã¿n·¥§G«ØWi-Fi / WiMaxµL½uÀ³¥Îºô¡A¦æ°Ê°Ó°È¤w½«¬°·¼é¡A¶i¦Ó¥[³t¥ø·~°Ó°ÈÀ³¥Î¡B¨«°Ê¦¡ºÞ²z¡BÆF¬¡ªºM¤Æ¦æ¾P¡CIT¤Hû¦p¦ó¨ó§U¥ø·~´x´¤¦æ°Ê°Ó°Èªº¯ß°Ê¡A¶Õ¥²±N¦¨¬°«nªº®Ö¤ß¾¯à¡C ¬°¤F´£ª@¸ê®Æ®w»P¦æ°Ê¸Ë¸mªº¾ã¦XÀ³¥Î¡A·L³nµoªíSQL Server 2005 Mobile Edition¡A¥H´Á¯à³z¹L·L³n¦Û®aªº¸ê..... ¥Î¹ê§@ªº¤è¦¡¤¶²ÐSQL Serverªº¾Þ§@¤¶±¥H¤Î¸ê®Æ®wªº«Ø¸m»P°ßÅ@¡A¥iÅý¤£´¿±µÄ²¹LSQL Server©Î¸ê®Æ®w³nÅ骺ŪªÌ¡A»´©ö¤W¤â¨Ã¦³®Ä¦aºÞ²z¸ê®Æ®w¡C ¥Î´`§Çº¥¶iªº¤è¦¡¤¶²ÐSQL«ü¥O¡A±q¸ê®Æ®wºÞ²z¡B¸ê®Æªí³]p¡A°O¿ý¼W§R»P½Æ»s¡B©µ¦ù¨ì¶i¶¥ªº¬d¸ß»P¥þ¤åÀ˯Á¡A¨Ã°w¹ïCTE¡B±Æ§Ç¨ç¼Æµ¥·s¼Wªº¥\¯à´£¨Ñ§¹¾ãªº»¡©ú¡A¥iÅýŪªÌ¤Jªù¶i¶¥¤@¦¸¾Ç»ô¡C ¹ý©³åªRT-SQL..... ¥»®Ñ±q°ò¥»ªºµ{¦¡¶}µo©Ò»ÝnªºT-SQL¶}©l¤¶²Ð¡A¥]¬AXML¡BWebªA°È¡B¾ã¦X.NET¶}µoSQLCLRª«¥ó¡BService Broker¡B³qª¾ªA°È¡B¹w¦sµ{§Ç»P¨Ï¥ÎªÌ¦Ûq¨ç¼Æ¡BIJµoµ{§Ç¨ì³Ì«áªº¥æ©öÂê©w³B²z»P¦h°ê»y¨t¨Ï¥Îµ¥½Ñ¦h¥\¯à¡AÅn¬A©Ò¦³µ{¦¡¶}µo¤Hû¥²³Æªº¸ê®Æ®w¾ã¦X«eºÝµ{¦¡¶}µoªº¥\¤Ò¡C¨C¤@³¹¸`³£·|¥ý³¯z¦U¸ê®Æ®w¥\¯àªº¨Ï¥Î±¡¹Ò»Pª`·N¨Æ¶µ¡A¦A·f°tVisual Stu..... ¥»®Ñ¤¶²Ð¸ê®ÆÜÀx¨t²Îªº²z½×¤Î¬ÛÃö§Þ³N¡A¥H¥©öªñ¤H¥B¥Í¬¡¤Æªº¤è¦¡¡A¤¶²Ð¥]¬A¸ê®Æ¼Ò¦¡¡BSQL¥Îªk¡B¨t²Î®Ä²v½Õ¾ã¡B¸ê®ÆÜÀxÀ³¥Î¤u¨ã¡A¥H¤Î¸ê®Æ±´°Éµ¥¬ÛÃöijÃD¡C¥R¤À¹B¥Î¦UºØ¹ê¥Î½d¨Ò¡A²`¤J²L¥X¸Ñ»¡»P§Y®ÉÀ³ÃҩҾǡA§@ªÌ¥H¦Û¨ªº¹ê¾Ô¸gÅç¥H¤Î«ÈÆ[ªº¨¤«×½s¼g¥»®Ñ¡A´£¨ÑŪªÌªº¹ê¥Î¸ê°T¡A¨Ã«Øºc§¹¾ã¸ê®ÆÜÀx·§©À¡C ¥»®Ñ¯S¦â ²LÅã©öÀ´¡G´¬°£³\¦hÃøÀ´ªº±M¦³¦Wµü¡A¤Î½ÆÂøªº¤½¦¡¡A¥H°ò¦¦ý..... ¥i¥H§»Æ[ªº¨¤«×¡A¤F¸Ñ¸ê®Æ®wªº¾ãÅé¹B§@¬[ºc¡A¥]¬A°ò¦·§©À¡B¶i¶¥ºÞ²z¡B±M®×¹ê§@¤Î¸ê®Æ®w¥¼¨Óµo®iªº®i±æµ¥¡A¬O°¾¦Vºî¦X©Êªº¸ê®Æ®w®ÑÄy¡C ¦b½d¨Ò³]p¤W¡A±N¥H¼ÒÀÀ¥ø·~¤º³¡ªºMIS¤Hû¡A«Ø¥ß¤ÎºÞ²z¸ê®Æ®w¡C¶i¤J¹ê°È¾Þ§@«e¡A·|¥ý»¡©ú¼ÒÀÀ¤½¥qªº²Õ´¬[ºc¡A¨Ã°²·QŪªÌ¬O¦¹¤½¥qªº¸ê°T¤Hû¡A¥²¶·¬°¤½¥q«Ø¸m¸ê®Æ®w¡A¨Ã¬°¦UÓ³¡ªù³]p¾A¥Îªº¤@©Î¦hÓ¸ê®Æ®w©ÎÀ³¥Îµ{¦¡¡C ¶i¤J¹ê°È¾Þ§@«á¡A..... ¥»®Ñ¥Hªì¦¸¾Ç²ß¸ê®Æ®w»P SQL »yªkªºÅªªÌ¬°¶D¨D¡M ¨Ã¥H³Ì·sªº Microsoft SQL Server 2005 ¸ê®Æ®w¨t²Î¨Ó¥Ü½d. º¥ý¤¶²Ð¸ê®Æ®wªº°ò¥»·§©À»PÃöÁp¦¡¸ê®Æ®wªº³W¹º§Þ¥©¡M §Y¨Ï¹ï¸ê®Æ®w¤£¼ô±xªºÅªªÌ¤]¯à°÷«Ü§Ö¶i¤Jª¬ªp¡C±µµÛ°w¹ï¸ê®Æ®wªº«Øºc¤ÎSQL »yªk´`§Çº¥¶iªº¸Ñ»¡¤Î¥Ü½d¡M ÅýŪªÌ¥R¥÷´x´¤ SQL Server ªº³]pºëÅè¡M »´ÃP«Ø¥ß©Ò»Ýªº¸ê®Æ..... SQL Server 2005±q³æ¤@ªº¸ê®Æ®w¤ÞÀºÂX¥R¦Ü¤ÀªR¡B³øªí¡B³qª¾µ¥¦h¥\¯à²£«~½u¡AµLºÃ¬°¸ê®Æ®wºÞ²z¨t²Î¾ð¥ß¤F¥t¤@Ó¨½µ{¸O¡C ¥»®Ñ¹Á¸Õ±q¶}µo¤HûªºÆ[ÂI¥Xµo¡A¤º®eµÛ«©ó¦p¦ó¶}µo®Ä¯à¡B¦w¥þ»Péwªº¥ø·~¯Å¸ê®Æ®w¨t²Î¡A¶i¦Ó¹B¥Î¸ê®Æ®w¡A´£ª@²Õ´ªº°Ó·~´¼¼z¡C°ò¥»¬[ºc»P¸ê®Æ»y¨¥ ¥HSQL Server 2005¶}µo¨t²Îªº¥DnijÃD¤Á¤J¡C±q°ò¥»ªººÞ²z¡B¾Þ§@¼¶¼gT-SQ..... ¦bMircrosoft SQL Server 2005¤W¥«¤§«e¡A¸ê®Æ±ÄÄq¦b²Îp»P¸ê°T¨âÓ»â°ì¤¤¤´¬O¦U¦Ûªíz¡A²Îp¬Éªº±M®aµÛ¤O©ó¸ê®Æ±ÄÄq¤ÀªR§Þ³Nªºµo®i»PÀ³¥Î¡F¦Ó¸ê°T¬Éªº±M®a«hP¤O©ó¸ê®ÆÜÀxªº¶}µo¡C¦]¦¹¡A¸ê®Æ±ÄÄqªºÀ³¥Î³nÅ餴¬O¥H²Îp³nÅ鬰¥D¡C¦p¤µ¡AMircrosoft SQL Server 2005¬ð¯}¤F³oӰϹj¡A¦b¸ê®Æ®w¨t²Î¤¤¡A«Ø¥ß¤F¡G¨Mµ¦¾ð¡B¨©¤ó¾÷²v¤ÀÃþ¡B®É..... ..... ¥»®Ñµ²¦XMicrosoft SQL Server 2000¸ê®Æ®wªº¹ê§@»P¸ê®Æ®wªººÞ²z§Þ¥©¡A±qÆ[©À¨ìSQL Server 2000¸ê®Æ®wªº«Ø¥ß¡BºûÅ@»PºÞ²z¡AÅýŪªÌ¥i¥H¤F¸Ñ¦p¦ó¦¨¬°¤@¦ìDBA¡]DataBase Administrator¡F¸ê®Æ®w¨t²ÎºÞ²zû¡^..... ..... ¸ê®Æ®w²z½×»P¹ê°È¦b¹q¸£¬ì¾Ç©M¸ê°TºÞ²zªº»â°ì¤¤¬O¤@ªù¬Û·í«nªº¾Çªù¡A¤×¨ä¬O¹ï¤j¾Ç³¡ªº¾Ç¥Í¨Ó»¡¡A¤£½×¬O´N·~©ÎÄ~Äò²`³y³£¬O¥²¶·«D¾Ç¦n¤£¥iªº¡C¥»®Ñªº¥Ø¼Ð¬O¥Î²`¤J²L¥Xªº¤è¦¡¤¶²Ð¸ê®Æ®w³]pªº²z½×¡A¨Ã»²¥H¦hÓ¹ê°È¤Wªº½d¨Ò¸Ô²Ó»¡©ú¤§¡A¥H«KÅý¾Ç²ßªÌ¯àÂùºÞ»ô¤U¦P®É¾Ç¦n¸ê®Æ®w³]pªº²z½×»P¹ê°È¡C ¥»®Ñ¤@¦@¦³¤G¤Q¥|³¹¡A¤º®e¬Û·íÂ×´I¡A¤jP¤W¤À¬°¸ê®Æ®w·§©À¤¶²Ð¡B¸ê®Æ®w³]p.....
¤½¤åºÞ²z¨t²Î 4..... ¥»®Ñ¯S¦â ¥»®Ñ¥H¸ê®Æ®w¨t²Î»PSQL ServerÀ³¥Î¬°¥D¶b¡A¤º®e¥Ñ²L¤J²`¡B´`§Çº¥¶i¨ó§U¤F¸Ñ¨ä³]pºëÀH¡A¨Ã³z¹L¦Û§Ú¾Ç²ßµû¶q¡AÅýŪªÌ¦³§¹¾ãªºÆ[©À¤Î¹ê§@¡C ¸ê®Æ®w¨t²ÎÆ[©À ·§z¸ê®Æ®wÆ[©À¡BÀô¹Ò¬[ºc¡BÀ³¥Î½d³ò¡A¤Î¶}µoªº¤ÀªR³]p¡C SQL Server¸ê®Æ®wºÞ²z¨t²ÎªºÀô¹Ò ±q¦w¸ËSQL Server 2000¶}©l°µ¨t²Î¤¶²Ð©M¦w¥þºÞ¨î¡A¨Ã»{ÃÑÃö³s¦¡¸ê®Æ®wªº«¬..... °T¨t²Î¤w¬O¥ø·~¤£¥i©Î¯ÊªºÄvª§¤O¤§¤@¡A¸ê®Æ®w«h¬O¸ê°T¨t²Îªº®Ö¤ß¡A®É¶¡¤@¤[¡A¥i¯à±Á{¸ê®Æ²Ö¿n¡B¨Ï¥Î¤H¼Æ¼W¥[¡B©Î·íªì¨t²Î³]p¤£¨}µ¥ì¦]¡A¦Ó¾ÉP®Ä¯àÅÜ®t¡C¥»®Ñ¹Á¸Õ©w¸q¡B§ä´M»P¸Ñ¨M°ÝÃD¡C²`¤J±´¨sSQL Serverªº¹B§@ì²z¡A¨ÃÀ˵ø»P¼ÒÀÀSQL Server¹B¦æ®É»P®Ä¯à¬ÛÃöªºÄ³ÃD¡A³z¹L¤u¨ã¨Ó±´¯Á°ÝÃDªº¨ÓÀs¥h¯ß¡A¶i¦Ó¨ó§U¸ê®Æ®wºÞ²z®v©Î¨t²Î¶}µo¤Hû®Ä¯à½Õ±Ð¯à¤Oªº..... ¥»®Ñ¥H¹ê»Úºô¸ô®Ñ©±¬°¨Ò¨Ó¸Ñ»¡¸ê®Æ¼Ò«¬³]p¡A±q¹êÅé¤Á³Îªº¤èªk¡B¼Ò«¬«Ø¥ß¼f®Ö»P¤ÀªR¡A©M¹êÅ骺©R¦W¼Ð·Ç¤Î»â°ì(Domain)ªº©w¸q»¡©ú¡C ¥Ñ²L¦Ó²`°t¦X¹ê»Ú¼Ò«¬½d¨Òªº«Ø¥ß¡A§¹¾ã±a»â±z¶i¤J¸ê®Æ¼Ò«¬ªº¥@¬É¡C¥»®Ñ¥H¸ê®Æ®w¬°¤¤¤ß¡A¤¶²Ð¦b°Ó·~¨t²Î¶}µo¤W¤£¥i©Î¯Êªº¸ê®Æ®w¶ì¼Ò(Data Modeling)¡C §Q¥ÎER(Entity Relationship)¹Ï¨Ó..... ..... ´£¨Ñ¤u§@»Ýn§Þ¥©»P¦Ò¸Õ¥²³Æª¾ÃѪºMicrosoft ©x¤è¦Û¾Ç®ÑÄy ¼ôŪ¥»®Ñ±z±N¨ã³Æ¦p¦ó§Q¥ÎSQL Server 2000¥ø·~ª©´£¨Ñ¥\¯à±j¤jªº¸ê®Æ®w¸Ñ¨M¤è®×ªº§Þ¯à¡A¥H¤Î³q¹LMCP¦Ò¸Õªº¸U¥þ·Ç³Æ¡C±z¥i¥H¨Ì¾Ú±zªº¾Ç²ß¶i«×¾\Ū¥»®Ñªº¤º®e¨Ã§¹¦¨¹ê§@½m²ß¡C¾\Ū§¹¥»®Ñ¤§«á±z¥i¥H¨Ï¥Î¥»®Ñ´£¨Ñªº¼Ò ÀÀ¦ÒÃD©M´úÅç¤u¨ã¿Å¶q¾Ç²ßªº¦¨®Ä¡A§ä¥X»Ýn¥[±jªº¦a¤è¡C¦b¹ê°È¤W«Ø..... ¥»®Ñ¬O¥HDB2 Universal Databaseªº³Ì·sª©¥»Version 8.1¬°°ò¦¡A°£¤F¤¶²Ð·sª©¥»¤¤ªº¦UºØ¥\¯à¤§¥~¡A§óµÛ«©óÃöÁp¦¡¸ê®Æ®w¨t²Î°ò¥»ì²zªºÄÄz¡A¦p¸ê®Æ®w³Æ¥÷»P´_ìì²z¡B¸ê®ÆÂê©wªºì²z¡B³Ì¨Î¤Æ³B²zªºì²z¡B¥H¤ÎSQL«ü¥Oªº«Øºcµ¥¡C¦b»¡©úì²zªº¦P®É¡A§ó·f°t¹ê¥Îªº½d¨Ò¡AÅýŪªÌÁA©jDB2¦UºØ¥\¯àªºÀ³¥Î¤è¦¡¡C¥»®Ñ¬ODB2¨Ï¥ÎªÌ¡B¶}µoªÌ¡B¥H¤Î..... °w¹ï¸ê®ÆÜÀx¨t²Îªºµo®i¡A¥Ø«e°ê¤º´¶¹M¦s¦bªº¥|Ó²{¶H¡G ²{¶H¤@¡G³\¦h¤H¹ï¸ê®ÆÜÀx«Ø¸m¤Î¹B¥Îªº¤F¸Ñ³£¬O¯È¤W½Í§L ²{¶H¤G¡G³\¦h¥N²z°Ó©MÅU°Ý¤½¥qÁöµM¼ô±x¥N²z©Î±M®×©Ò¿ï©wªº¤u¨ã¡A¦ý¹ê»Ú¤W¹ï¸ê®ÆÜÀx¨t²Î«Ø¸m¯Ê ¥F§¹¾ãªºÁA¸Ñ ²{¶H¤T¡G¥Ø«e°ê¤º¥i°Ñ¦Òªº¸ê®ÆÜÀx¬ÛÃö®ÑÄy¥u¦³ì¤å®Ñ ²{¶H¥|¡G¤£ÁA¸Ñªº¤H¥H¬°¸ê®ÆÜÀx«Ø¸m¤u§@¡A¨ä¹ê´N¬O¬£´X¦ìÀ´¸ê®Æ®wªº³nÅé¤uµ{®v´N¥i¥H¸Ñ¨M ..... ¥»®Ñ±j½Õ¹ïSQL Server¸ê®Æ®wªº¤F¸Ñ»PÀ³¥Î¡A±q¸ê®Æ®wªº¤ÀªR³W¹º¨ì¸ê®Æ®wªº¹ê»Ú³]p¡A¥[¤WT-SQL«ü¥Oªº¼¶¼g¡AÅýªì¾ÇªÌ¯à°÷«ö¹Ï¯ÁÆk¡A»´ÃP¾Ç²ßSQL Server¡A¦P®É«Øºc§¹¾ãªº¸ê®Æ®wÆ[©À¡A¤]¯à©ú¥Õ¸ê®Æ®w¤¤¦UºØª«¥óªº¨Ï¥Î»P°ò¥»µ{¦¡»y¨¥ªº¼¶¼g¤è¦¡¡A¬Oªì¾ÇªÌ»P¶iת̪º³Ì¨Î°Ñ¦Ò®ÑÄy¡C ..... PostgreSQL¬O¤@®Mª«¥ó¾É¦VÃö³s¦¡¸ê®Æ®w¨t²Î¡A´X¥G¥i¥Î©ó©Ò¦³ªº¥¥x¡B¨Ï¥Î§¹¥þ§K¶O¡Bµ{¦¡½X§¹¥þ¤½¶}¡B¤ä´©¸ê®Æ®w¼Ð·Ç»y¨¥SQL¤w¸g¦¨¬°³Ì¥ý¶iªº¸ê®Æ®w¨t²Î¡C ¥»®Ñ¥þ¤å§Q¥Î²LÅã©öÀ´ªº¤è¦¡ªí¹F¸ê®Æ®w¤§¤¤«nªºÆ[©ÀÅýŪªÌ¿Ä·|³e³q¡A¨Ã¥B¥HStep-by-Stepªº¤è¦¡±a»âŪªÌ¦w¸ËPostgreSQL¸ê®Æ®w¡C¨Ã°t¦X§¹¾ãªº®×¨Ò¡Ð¡ÐÓ¤H¹Ï®ÑºÞ²z¨t²Î§@¬°¥þ®Ñªº..... ..... ¾Ç²ß¦p¦ó¥ÎSQL Server 2000¡AVisual Basic .NET¡A»PXML¨Ó±N¸ê®ÆÂà´«¦¨¸Ñµª ¨Ï¥Î³o¥»µ{¦¡û¥²³Æªº¾É¤Þ®ÑÄy¡A¨Ó§ä¨ì±N¸ê®ÆÂà´«¦¨¦³®Äªº¥ø·~¸Ñµªªº³Ì§Ö³t¤è¦¡¡C±z·|¾Ç¨ì¥ÎT-SQL¨Ó°µ¸ê®Æ¦s¨ú¡A¸ê®Æ¾Þ§@¡A»P¸ê®Æ©w¸qªºSQL Serverµ{¦¡³]p§Þ³N¡C±zÁÙ·|¾Ç¨ì¦p¦óÅýVisual Basic .NET¡AMicrosoft V..... ..... Access±M®×¡A¤£¦P¸ê®Æ®wª©¥»ªº¤¶²Ð»P¦w¸Ë¡AAccess±M®×¸ê®Æªí¡A¸ê®Æ®w¹Ïªí¡AÀ˵øªí¡A¹w¦sµ{§Ç¥H¤ÎTransact-SQL¡C ªí³æ»P³øªí¡C ADOµ{¦¡³]p¡AConnectionª«¥ó¡ARecordsetª«¥ó¡ACommand»PParameterª«¥ó¡A¥H¤ÎADO Event¡C Access Upsizing Assistant¤u¨ãªº¨Ï¥Î¡A¥H¤ÎDAOÂಾ¦Ü..... ¥»®Ñ¤£¶È¹ï¸ê®Æ®wºÞ²z¨t²Î²z½×§@¦³¨t²Îªº¤¶²Ð¡A§@ªÌ¥©«ä¦w±Æ¤@¨t¦C´`§Çº¥¶iªº¹ê¥Î½d¨Ò¡A¹ê»Ú¤W¾÷¾Þ§@ÅýŪªÌ»´ÃP¾Ç·|SQL Server-- ¤¤µØ¹q«H¼Æ¾Ú¤À¤½¥qÁ`¤uµ{®v ¤ý¤å¤s³o¬O¤@³¡¤º®e¸Ô¹ê¡A½d¨ÒÂ×´Iºë±m¹ê¥Î¡A¨Ã³v¨B¤Þ¾ÉŪªÌ¼ô±xSQL Server ±j¤jªº¥\¯à¡C ¥»®Ñ¹ïŪªÌ·|·P¨ì¶VÃøÀ´ªº¦a¤è¡AÁ¿±o¶V²M·¡¯u¬O¤@³¡¥O¤H¿E½àªº§¹¾ã¸ê®Æ®w±Ð¬ì®Ñݤu¨ã®Ñ¡A¦b¦¹..... SQL Server 2000¸ê®ÆÂà´«ªA°È¡]DTS¡^¬O¨t²Î¶}µo¤¤¼sªxÀ³¥Îªº¤u¨ã¡A¥»®Ñ¸ÔºÉ´yz¦p¦óÀ³¥ÎDTS¦b²§½è«¬¸ê®Æ®w¤¤¶i¦æ¤£¦P®æ¦¡ªº¸ê®ÆÂà´«¡A¶i¦Ó¨ó§U¸ê®Æ®w¾ã¦X¤Î¤ÀªR§ó¤W¼h¼Ó¡C¥»®Ñ¥H¦h¹F30Ó½d¨Ò¸Ñ»¡¡AÅý§A¿Ë¨ÅéÅçDTSªº¶ø§®¡A¬O¶}µo¤Hû¤£¥i¿ù¹Lªº¤@¥»¹ê°È¤u¨ã®Ñ¡C..... ¥»®Ñ»¡©úXML¦p¦ó¬ð¯}¥Ø«e¶Ç²ÎÃöÁp¦¡¸ê®Æ®wªº§ô¿£¡A¦Ó¦¨¬°SQL Server¹ï¥~·¾³qªº¤¤¤¶¸ê®Æ¼Ð·Ç®æ¦¡¡A§A¥i¥H³z¹L½d¨Ò¾É¤Þ¡A§¹¾ã¾Ç²ßXML»PSQL ServerªºÀ³¥Î¡C..... Transact-SQL¬OSQL Server 2000³Ì°ò¥»¥B«nªº¤@Ó³¡¤À¡A²¦³º«áºÝSQL Server¸ê®Æ®w¤¤ªºµ{¦¡¡Bµ{§Ç¡B»P¨Ï¥ÎªÌ¦Ûq¨ç¼Æ¬Ò¬O¥ÑTransact-SQL¾áºõ§¹¦¨¡C¦]¦¹¦pªG±z¤£¼ô±x¦p¦ó¼¶¼gTransact-SQLµ{¦¡½X¡Aµ´¹ïµLªkºc«Ø¥X¤@Ó°ª®Ä²v¡B¥\¯à±j¤j¡B¥B𷪺¨t²Î¡C Transact-SQL¬OSQL Serverªº°ò¦»PÆF.....
¤½¤åºÞ²z¨t²Î 5¥»®Ñ¯S¦â PostgreSQL¬O¤@®M§¹¥þ§K¶O¦Ó¥BOpen Sourceªº (ORDBMS) ª«¥óÃöÁp¦¡¸ê®Æ®wºÞ²z¨t²Î¡A±q1986¦~¦Ü¤µ¤]¤w¸g¤Q´X¦~¤F¡C¥Ñ©óInternetªºµo®i§Ö³t¤ÎOpen Sourceªº·§©À¡A±a°Ê¤FPostgreSQLªº§Ö³tºt¶i¡A¥Ø«e¤w¦³¼s¤jªº¨Ï¥Î±Ú¸s¡A¥¦ªº¥\¯à©M¨ä¥¦«D°Ó·~©Ê¸ê®Æ®w¬Û¤ñ¸û¡A¦³¹L¤§¦ÓµL¤£¤Î¡A¦Ó¥B¥i«Ø¸m©ó¦hºØ¥¥x¡B¤ä´©¸ê..... ŪªÌ¥i¥HÂǵۥ»®Ñ¼sªxªº¸ê·½¡A¶}µo±j©TªºSQL Server 2000¸ê®Æ®w©M¸ê®Æ®wÀ³¥Îµ{¦¡¡C¥»®Ñ¸ÑÄÀ¦p¦ó¨Ï¥ÎTransact-SQL¦s¨ú©M¾Þ§@¸ê®Æ¡A«Ø¥ß¥\¯à±j¤j¡B¨ãADO¡BDAO¡BDBCDirect¡BODBC©MRDOªºWindowsÀ³¥Îµ{¦¡¡A¨Ã¥B¶}µo¾ã¦X¡B¸ó¥¥x¡B¨ãASP©MXMLªºWebÀ³¥Îµ{¦¡¡C¦¹¥~¡AŪªÌ¤]¥i¥HÀò±oSQL Server 2000ºÞ..... ¸ÔºÉ¸Ñ»¡DTS«Ê¸Ëªº¦U¶µ²Õ¦¨¤¸¯À»PDTS¤u§@¡A«OÃÒ¥´¤U¤ã¹ê®Ú°ò¡C ·f°t½d¨Ò¤¶²Ð´M¬d¬d¸ß¡B¸ê®Æ¾É¦V¬d¸ß¡B»P¦UÃþ«¬Äæ¦ìÂà´«§@·~¡A§U±z«Ø¥ß¥¿½T¨Ï¥ÎÆ[©À¡C ¦h¶¥¬q¸ê®ÆÀ°®ú¹ý©³¬ã¨s¡C ²Ó»¡¦p¦ó¨Ï¥ÎActiveX Script¨Ó¦ÛqÂà´«§@·~¡B¦s¨úADO¸ê®Æ¿ý¶°¡B»P¨Ï¥ÎÀɮרt²Îª«¥ó¡C °ÊºAÄݩʤu§@¹ý©³¬ã¨s¡C »¡©ú¦p¦ó¨Ï¥ÎDTS¨Ó³B²zAnaly..... ..... ..... ²©ú©öÀ´-§Y¨Ï¬O±q¥¼±µÄ²¹LSQLªºÅªªÌ¤]¯à«ö³¡´N¯Z¨Ó¾Ç²ß¡C ÝÅU²z½×»P¹ê§@-¥»®Ñ¤£»´©¿°ò¦·§©Àªº«n©Ê¡A¨Ã«¹ê§@»P²z½×¡C Ý«³W®æ»P²£«~-¥»®Ñ¥HSQL-92¬°·Ç¡A¦P®É¦Ò¶q¨ìOracle¡BSQL Server¡BAccessµ¥²£«~ªº¹ê»Ú±¡§Î¡C..... ¨Ï¥Î¹w¦sµ{§Ç¨Ó¼¶¼g¨ã¦³¼u©Ê¡B¦Ó¥B®Ä²v·¥°ªªºSQL ServerÀ³¥Îµ{¦¡¡C¥»®Ñ¡mSQL Server 2000¹w¦sµ{§Çµ{¦¡³]p¡n±N§i¶D§A¦p¦ó¨Ï¥ÎTransact-SQL¨Ó³]p¡B°£¿ù©MºÞ²z¦Ûqªº¹w¦sµ{§Ç¡B¨ç¼Æ¡B¥H¤ÎIJµoµ{§Ç¡C§A±N·|¾Ç¨ì¡G¨Ï¥ÎEnterprise Manager¡BQuery Analyzer¡BVisual Basic¡B©MVisual St..... ¥»®Ñ¬°¹q¤l°Ó°ÈÀ³¥Î³nÅ骺¸ê®Æ®w´£¨Ñ¤@Ө㩵®i©Ê¡B«½Æ©Ê¤Î¥i¾a©Êªº°ò¦¡A¥]§t¦w¸Ë¡B½Õ¾ã¡B¨t²Î¬[³]¡B¦w¥þ¾÷¨î¡BÀɮ׺޲z¡B¸ê®Æ¾Þ§@¡B½Æ¼g¡B¦Û°Ê¤Æ¥H¤Î³Æ¥÷ÁÙì¡C¨ä¤¤¥]§t¦³³Ì·sªº¸ê°T¡B¹ê¨Ò¤Î¹ê¥Îªº¸Ñ¨M¤è®×¡C¨Ã±q¹ê°È¸gÅç¤@¸`¤¤¡AÂI¥X¤@¨Ç§@ªÌ¦bSQL ServerºÞ²z¸gÅç¤Wªº§Þ¥©¡C¥»®Ñ¬°SQL Server DBA̤£¥i©Î¯Êªº«n¸ê·½¡C ³]©w¡B½Õ®Õ©MºûÅ@SQL ..... ..... ..... Easily Manage Your SQL Server¡M AnyTime¡M AnyWhere! Åý±zÀH®ÉÀH¦a³£¥i¥H»´ÃP´x±±SQL Server 2000! ¥»®Ñ«ÂI µ½¥ÎSQL ServerªºµøÄ±¤ÆºÞ²z¤u¨ã-Enterprise Manager¡A»´ÃP¾r¶¿»P¾ã¦X±z´xºÞªºSQL Server ¦h¥xSQL ServerªººÞ²z ¦p¦ó±q»·ºÝ¨ÓºÞ²z..... Àò±o±zªº¶i¯Å§Þ¥© ¶È¶È¦b21¤Ñ¤º¡A±z´N·|¨ã³Æ©Ò¦³¤É¯Å¥H¤Î¯à°÷°ª®Ä²v¾Þ§@©Ò»Ýnªº§Þ¥©¡C¦b³oÓ§¹¾ãªº±Ð¾Ç¤¤¡A±z±N´x´¤°ò¥»ª¾ÃÑ¡A¨Ã¶i¤@¨BÁA¸Ñ§ó¶i¶¥ªº¯S©Ê¤Î·§©À¡C ÁA¸ÑMicrosoft SQL Server 2000ªº°ò¥»ª¾ÃѨüô¥Î¨ä¥Dn¥\¯à ³z¹L½m²ß¤Î¹ê»Ú¨Ò¤l¡A¾Ç²ß°ª®Ä²v¦a¨Ï¥ÎSQL Server³Ì·s¤u¨ã¤Î¯S©Ê Àò±oSQL Server»â°ì¤ºªº»â¾ÉÅv«Â..... ¥»®Ñ¯S¦â¡G ¥»®Ñ¥]§tSQL Server 2000©ó©Ò¦³À³¥Î³nÅé¶}µo®É©Ò»Ýªº§Þ³N¡C ¥þ®Ñ©Ò´£¤Îªº§Þ³N¡A§¡¥H²M·¡ªº»¡©úÅý±z¨³³tÁA¸Ñ¡C ¥þ®Ñ»²¤§¥H¹Ï¸Ñ©M½d¨Ò¦¡ªºÁ¿¸Ñ¡AÅý±z¥i¥H¨ãÅé¦aÁA¸ÑSQLñ¸û²`¤J»P¶i¶¥ªº§Þ³N¤º®e ±Ð®v±Â½Ò¤j«K§Q¡G¬°¤F¥ô½Ò±Ð®v¤W½Ò¤è«K¡A¥»®Ñ©Ò¦³¤º¤å«T»s§@¦¨PDFÀÉ¡AÅý±Â½Ò±Ð®v¦Û¥Ñ¨Ï¥Î¡AÅý¦Ñ®v¥i¥H¦b¦³¼s¼½±Ð¾Çªº±Ð«Ç±Ð¾Ç¡A©Î»s§@¦¨§ë¼v¤ù¨Ó..... PostgreSQL´X¥G¥i¥Î©ó©Ò¦³Unix¥¥x¡B¨Ï¥Î§¹¥þ§K¶O¡Bµ{¦¡½X§¹¥þ¤½¶}¡B¤ä´©¸ê®Æ®w¼Ð·Ç»y¨¥SQL¡A¤w¸g¦¨¬°³Ì¥ý¶iªº¸ê®Æ®w¨t²Î¡C ¥»®Ñ¤¶²ÐPostgreSQLªº¦w¸Ë¡B¨Ï¥Î¤èªk¥~¡AÁٸѻ¡¦p¦ó¨Ï¥ÎTcl/Tk¡BC¡BPHP¡BPerl¡BJavaµ¥¦UºØµ{¦¡¤¶±»s§@À³¥Îµ{¦¡¤Î¨ä¥¦«n¬ÛÃö¸ê°T¡C±qÀ³¥Îµ{¦¡ªº¨Ï¥Î¤èªk¨ìì©l½Xªº¤º®eµ¥³£¥H¨ÒÃD¸Ô²Ó¸Ñ»¡¡AÅý§A¹ê..... ¥»®Ñ¤£¶È¹ï¸ê®Æ®wºÞ²z¨t²Î²z½×§@¦³¨t²Îªº¤¶²Ð¡A§@ªÌ¥©«ä¦w±Æ¤@¨t¦C´`§Çº¥¶iªº¹ê¥Î½d¨Ò¡A¹ê»Ú¤W¾÷¾Þ§@ÅýŪªÌ»´ÃP¾Ç·|SQL Server ¤¤µØ¹q«H¼Æ¾Ú¤À¤½¥qÁ`¤uµ{®v ¤ý¤å¤s ³o¬O¤@³¡¤º®e¸Ô¹ê¡A½d¨ÒÂ×´Iºë±m¹ê¥Î¡A¨Ã³v¨B¤Þ¾ÉŪªÌ¼ô±xSQL Server ±j¤jªº¥\¯à¡C¥»®Ñ¹ïŪªÌ·|·P¨ì¶VÃøÀ´ªº¦a¤è¡AÁ¿±o¶V²M·¡..... ²Ä¤@³¹ °ò¥»·§½×»P¥»®Ñ¾ÉÄý ²Ä¤G³¹ ¨t²Î«Ø¸m¶·ª¾ ²Ä¤T³¹ ¦øªA¾¹ºÞ²zªì¨B ²Ä¥|³¹ ¸ê®Æ®wªººÞ²z»PºûÅ@ ²Ä¤³¹ ¸ê®Æ®wª«¥óªººÞ²z ²Ä¤»³¹ ¸ê®ÆÂà´«ªA°È(DTS) ²Ä¤C³¹ ´x±±¸ê®Æ¥æ©ö(Transaction) ²Ä¤K³¹ Âê©w(Lock) ²Ä¤E³¹ ¸ê®Æ®wªº´_ì ²Ä¤Q³¹ ½Æ¼g(Replication) ²Ä¤Q¤@³¹ ¤u§@¦Û°Ê¤Æ ²Ä¤Q¤G³¹ ºÞ²z¦øªA¾¹¦w¥þ©Ê ²Ä¤Q¤T³¹..... ³o¬O¤@¥»¾A¦Xªì¾ÇªÌªºSQL Server 2000½d¨Ò®Ñ¡A¥á¶}¨º¨ÇÁ}Àߪº²z½×¡A¥»®Ñ´£¨Ñ¹ê¥Îªº½d¨Ò¡B²LÅã©öÀ´ªº¤å¦r»¡©ú¦A¥[¤W²³æªº¹Ï¤ù¡AÅý±z¥i¥H«Ü§Ö¹ïSQL Server 2000¦³¤@Ó¥þ±©Êªº¤F¸Ñ¡C..... §¹¥þ¹ê°È¾É¦V¡A¥HManagement.surpro.com¤½¥q¬°¨Ò¡A±q¦w¸ËSQL Server2000¨t²Î¡B¦w¸Ë°õ¦æÓÅé(Default Instance)¡B¸ê®Æ®wª«¥ó(Database Object )ªº«Ø¥ß¡BT-SQL»yªkªº¤¶²Ð¡B¹w¦sµ{§Ç(Stored Procedure )ªº¨Ï¥Î¡BSQL Server 2000¸ê®Æ®wªº³Æ¥÷(Backup)»P½Æ¥»(.....
¤½¤åºÞ²z¨t²Î 6SQL Server 2000ª©¥»¹ï©óXMLªº¤ä´©¬O¤@¶µ«¤jªº§Þ³N²·s¡A¥»®Ñ¯S§O°w¹ïXMLªº»yªk§@¤F¤@µf¤ÀªR¡A¦P®É¤]¥H¹ê§@¤è¦¡¡A¸Ô²Ó¤¶²Ð¦p¦ó¦bSQL Server¤º¨Ï¥ÎXMLªº§Þ³N¡C ¥»®Ñ¯S§O°w¹ïMicrosoft.NET Enterprise Server¤¤ªº¦U¶µ²Õ¦¨ªº¦øªA¾¹¡A§@¤Fªì¨B¤¶²Ð¡A¨Ã¥B°Q½×¨ì¥¼¨ÓMicrosoft¦b.NET¥¥x¤Wªºµ¦²¤µo®i¡A..... ¥»®Ñ¯S¦â¡G ´`§Çº¥¶i¤è¦¡¾Ç²ßSQL Server 2000¡C ±j½Õ²z©À»P¹ê°È°t¦X¡A°t¦X§¹¾ãªº¬[ºc¹Ï»P¹Ï¸Ñ¡BÀ³¥Îµ{§ÇÅý±z»´ÃP¶i¤JSQL Server 2000½dÃ¥¡C ±qµøÄ±¤Æ¦Ü«ü¥OÀ³¥Î¡A±q«Ø¸m¨ì°ò¥»ºÞ²z¡AÅý±zÁA¸ÑSQL ServerºëµØ©Ò¦b¡C ¥»®ÑªþÃØ¡GSQL Server 2000 120µû¦ôª©..... ..... ..... §@ªÌ±q¸ê®ÆÜÀxªº·§©ÀµÛ¤â¡M»¡©úOLAP¤ÀªR¸ê®Æ®wªº«Ø¸m¡M¥Ñ²L¤J²`ªº±a»â¨Ï¥ÎªÌ«Ø¥ß¤ÀªRªºCube»P¸ê®Æ±ÄÂ^¼Ò«¬¡M¨Ã»¡©ú¦p¦ó³z¹L«eºÝªº¸ê®Æ¤ÀªR¤u¨ã¦pExcel©ÎWeb¨Ó¨ú±o¤ÀªRµ²ªG¡MÅý¥ø·~¥D¤£¦ý¥i¥H¥Î³Ì¤Öªº®É¶¡¡M³B²z¨Mµ¦¤ÀªR©Ò»Ýªº¸ê®Æ¡M¨Ã±q¤¤±o¨ì¦UºØ¤£¦Pªº¤ÀªRµ²ªG¡M§@¬°¸gÀç¨Mµ¦ªº°Ñ¦Ò..... ¤¶²Ð¸ê®Æ®wªº°ò¥»·§©À»PÃöÁp¦¡¸ê®Æ®wªº³W¹º§Þ¥©¡A§Y¨Ï¹ï¸ê®Æ®w¤£¼ô±xªºÅªªÌ¤]¯à°÷«Ü§Ö¶i¤Jª¬ªp¡C±µµÛ°w¹ï¸ê®Æ®wªº«Øºc¤ÎSQL»yªk®i¶}´`§Çº¥¶iªº¸Ñ»¡¤Î¥Ü½d¡AÅýŪªÌ¥R¥÷´x´¤SQL Serverªº³]pºëÅè¡A»´ÃP«Ø¥ß©Ò»Ýªº¸ê®Æ®w¨t²Î¨Ãµ½¥[À³¥Î¡C ¥t¥~¡A¦b«Ø¥ß¸ê®Æ®w¡B¸ê®Æªí¡BÃöÁp¡BÀ˵øªí¡B¯Á¤Þµ¥ª«¥ó®É¡A°£¤F¥i¥H¨Ï¥ÎSQL»yªk¨Ó¾Þ§@¥~¡ASQL Server 20..... ¥»®Ñ¯S¦â¡G SQL Server 2000 «Ø¸m»PºÞ²z¤â¥UµÛ«¦bSQL Server 2000ªº¸ê®Æ®w«Ø¸m»PÀ³¥Î¼h±¡A±q¸ê®Æ®w¨t²Î«Ø¸m¡B¦UºØ¸ê®Æ®wª«¥óªº«Ø¸m§Þ¥©¡A©µ®i¦Ü«eºÝÀ³¥Îµ{¦¡©ÎWebÀ³¥Î¨t²Îµ¥¦U¶µ±M®×ªº¶}µo¡A³£¦³¹d²ÓÃû¿òªº²`¤J¤¶²Ð¡AÅý±z¥i¥H´`§Çº¥¶iªº»{ÃѨì¡¥ÎSQL Server 2000³oÓ¸ê®Æ®w¥¥x¡AÅýSQL Server 2000¦¨¬°..... ..... ¥»®Ñ¥H²`¤J²L¥Xªº¤¶²ÐSQL Server 2000»PAccess 2000ªº·f°t§@·~¬°¥Øªº¡A¥ÑSQL¸ê®Æ®wªº«Ø¥ß¡BSQL Server¨C¤@Ó¤u¨ãªº¨Ï¥Î¤èªk¡B²©öªºSQL»y¨¥¸Ñ»¡¶}©l¡A±µµÛ¶i¤J¨Ï¥ÎSQL Server©M Access¨Ó¬[³]¤@Ó¥D±q¦¡¬[ºcªº¨t²Î¡A¨ä¤¤¹ï¦øªA¾¹ªº·s¦s¨ú¤è¦¡¢w§Yªñ¨Ó¿¨üª`¥ØªºADO³o¤@¤è±¡A§ó¬Oªá¤F¬Û·í¦hªº½g´T°µ¤F¸ÔºÉªº¤¶²Ð..... ¥»®Ñ¥H´`§Çº¥¶iªº¤è¦¡¨Ó¤¶²ÐSQL Server¡A±q¦w¸Ë©M°ò¥»·§½×°_¦Ü¸ê®Æ®wª«¥ó(¸ê®Æªí¡AÀ˵ø¡AIJµoµ{§Ç...)ªº«Ø¥ß©M¨Ï¥Î¡C ¥t¥~¤]¤¶²Ð¤FSQL Serverªº¨t²ÎºÞ²z¦p¦w¥þ»{µý¡B³Æ¥÷¡B½Æ¼gµ¥¡A¤ÎSQL Server©Ò´£¨Ñªº¤@¨Ç¤u¨ã¦p¡G¸ê®Æ²¾Âà¤u¨ã(DTS)¡BAnalysis Services(OLAP)¡BQuery Analyzerµ¥¡A¨Ã¹ï©ó..... ..... ..... ¤¶²Ð¦p¦ó¦w¸ËSQL Server 2000 ±Ä¥Î´`§Çº¥¶i¤è¤@¦¡¡A¤¶²Ð¦p¦ó«Ø¥ßSQL Server¸ê®Æ®w»P¨ä¤¤ªº¦UºØª«¥ó¡A±Ä¥Î½d¨Ò¾É¤Þ¤è¦¡Åý±z»´ÃP¶i¤JSQL Server¸ê®Æ®w¦øªA¾¹»â°ì¡A±j½ÕµøÄ±¤Æ¤u¨ã»P«ü¥O¬Û¦VÀ³¥Î¡A§¹¥þ¤¶²ÐSQL Server2000·s¼W¯S©Ê¡A¨Ã¥B¤¶²Ð¦p¦ó«Ø¸m¤@Ӥ䴩XMLªº¸ê®Æ®w¡C ¤¶²Ð¦p¦ó¦w¸ËSQL Server 2000 ¡A..... ..... ¦b¥»®Ñ¤¤¡A§ÚÌ´`§Ç¦a¨Ó¤¶²ÐSQL Server 2000¦b¸ê®Æ®w³]p¡B¸ê®Æ®wªººÞ²z¡BÀ˵øªí¡B¯Á¤Þµ¥¤è±³£´£¨Ñ¤F¸Ô²Óªº»¡©ú¡AÅý±z¥i¥H¥R¤À¦a¤F¸ÑSQL Server 2000¦b³]p¤è±ªº¥\¯à¡A¨Ã´£¨Ñ½d¨Ò¯àÅý±z¦b¾Ç²ßªº¹Lµ{¤¤¯à°÷§ó»´ÃP´x´¤SQL Server 2000¡C..... ¥»®Ñ¾A¦X¥Ø«e¾á¥ôSQL SEVER7ªº°ò¦®ÑÄy¡A§Ú̲[»\³\¦hDBA ªº»â°ì¡A¦ý§Ṳ́]§R¥h¤FDBAªº¤@¨Ç°ò¥»ª¾ÃÑ¡A¹³¬OMIDDLE TIER«eºÝµ{¦¡³]p¤§¬y¡A§Ú̧怜¿ý§ó¬°²`¤JªºÄ³ÃD¡A¹³¬OMTS¡BSQL-DMO©M¥þ²y¸ê°Tºôµ¥µ¥¡C §Ṵ́²³]ŪªÌ¦bINTEL ¥¥x¤W°õ¦æSQL SEVER7ªº¼Ð·Çª©¡AYŪªÌªº°õ¦æ¥¥x¤£¦P¡A¨º»òŪªÌ©Î³\·|¬Ý¨ì¤@¨Ç¥Dn®t²§..... SQL Server 2000¬O·L³n¸ê®Æ®w¨t²Îªº¥Nªí§@¡A§ó¬O¤½¥q»P¥ø·~¥Î¨Ó«Ø¥ß¦UºØ°Ó·~À³¥Îµ{¦¡ªº³Ì¨ÎÃöÁp¦¡¸ê®Æ®w¡C°£¤FªÃ«ù©ö¾Ç¡B©ö¥Îªº©v¦®¥~¡A§ó¥[±j¤FÂX¥R©Ê¡B¥i¾a©Ê¡B°õ¦æ®Ä¯à¥H¤Î¸ê®Æ¤ÀªRµ¥¯à¤O¡A¥i»¡¬O¸ê®Æ®w¨t²Îªº³Ì¨Î¿ï¾Ü¡C¥»®Ñ°£¤F¸Ô²Ó¤¶²Ð¦p¦ó¨Ï¥Î»PºÞ²zSQL Server 2000¨t²Î¤§¥~¡A§@ªÌÁÙºë¤ß³]p¤F¤@¥Ü½d¸ê®Æ®w¡C¸Ó¥Ü½d¸ê®Æ®w¤¤°£¤F¦³¥Ü½dªº¸ê..... ¡i¤º®e¤¶²Ð¡j ±q SQL Server 2000 ªº°ò¥»¬[ºc¶}©l¡A¸Ô²Ó¤¶²Ð SQL Server 2000 ªº¦w¸Ë³W¹º¡B¸ê®Æ®wªº«Ø¥ß»P³W¹º¡B¦w¥þ©ÊºÞ²z¡B³Æ¥÷»P½Æ»s¡B¦øªA¾¹³Ì¨Î¤Æµ¥¦U¶µºÞ²zªÌ©Ò»Ý±¹ïªº¤u§@©MijÃD¡C¦¹¥~¤]¤¶²Ð¤F¸ê®ÆÜÀx¤Î¸ê®Æ±ÄÂ^ (Data Mining) ªº¬ÛÃö¤º®e¡A±q°ò¥»ªº¸ê®Æ¡BÜÀxªº·§©À¡BSQL Server 2000 ¹ê§@¸ê®ÆÜÀx¡B.....
¤½¤åºÞ²z¨t²Î 7¥Ñ¥xÆW·L³n±M·~Á¿®v¤ÎÅU°Ý°õµ§¡B¥ø¹º¡C ¨t²Î¤Æ¦a¤¶²ÐMicrosoft(r) SQL Server(tm) 2000¤¤¤åª©ªº¾ãÅé¬[ºc¡A¬°¤é«á¾Ç²ß³þ¤U¨}¦n®Ú°ò¡C «ü¾É±z¦p¦ó«Ø¸m°ª«~½è»P§¹µ½ªº¸ê®Æ®w¡C ²Ó»¡¦p¦óºc«Ø¸ê®Æªí»P±ø¥ó¬ù§ô¡A¥H½T«O¸ê®Æªº§¹¾ã©Ê¡C ²Ó»¡¦p¦óµ½¥Î¯Á¤Þ¨Ó´£ª@®Ä²v¡C ¬d¸ß¡B¶×¾ã¡B²Îp¡B»P¤ÀªR¸ê®Æ¬O¤@¤Á¸ê®Æ¦s¨ú§@·~ªº°ò¦¡A¥»®Ñ¬°±z²Ó»¡±qÀY¡C ¸Ô..... ..... §@ªÌ²¤¶ Divya Chaturvedi ¼w¦{¥ð¤h¹yªºº®uSQL Server±M®a¡A¦o¾á¥ô¤½¥q¥ø·~¤§SQL ServerÅU°Ý¡A¨Ã³]p¡B¬[³]¤ÎºûרϥÎSQL Serverªº¤j«¬¨t²Î¡A¦b1991¦~SQL Server¶}©lÀ³¥Î®É¡A¸Ó¤½¥q¬O¬ü°ê°ê¤º¥Dnªº¸ê°TªA°È¤½¥q¡C Divyaªº¶l¥ó«H½c¡Gdchaturvedi@norrellis.com P..... ¥»®Ñ¤£¶È¹ï¸ê®Æ®wºÞ²z¨t²Î²z½×§@¦³¨t²Îªº ¤¶²Ð¡A§@ªÌ¥©«ä¦w±Æ¤@¨t¦C´`§Çº¥¶iªº¹ê¥Î ½d¨Ò¡A¹ê»Ú¤W¾÷¾Þ§@ÅýŪªÌ»´ÃP¾Ç·|SQL Server¡]¤¤µØ¹q«H¼Æ¾Ú¤À¤½¥qÁ`¤uµ{®v ¤ý¤å¤s¡^ ³o¬O¤@³¡¤º®e¸Ô¹ê¡A½d¨ÒÂ×´Iºë±m¹ê¥Î¡A¨Ã ³v¨B¤Þ¾ÉŪªÌ¼ô±xSQL Server ±j¤jªº¥\¯à¡C ¥»®Ñ¹ïŪªÌ·|·P¨ì¶VÃøÀ´ªº¦a¤è¡AÁ¿±o¶V²M ·¡¡A¯u¬O¤@³¡¥O¤H¿E½àªº§¹¾ã¸ê®Æ®w±Ð¬ì®Ñ ݤu¨ã®Ñ¦b..... ..... ..... ³o¥»¤â¥U¬O¬°¦³±M·~ªºµ{¦¡³]p®v©Ò¼¶¼gªº¡A¨Ï¥Î¥¦¥iÅý§Aºë³q¸ê®Æ®w¨t²ÎªººÞ²z©M¸ê®Æ®wÀ³¥Îµ{¦¡ªº¶}µo¡C¥»®Ñ°£¤F¤¶²Ð§¹¾ãªºSQL Server®Ö¤ßÆ[©À¡A¨Ã¦b®Ñ¤¤¤ÎCD-ROM´£¨Ñ¸Ô²Óªºµ{¦¡½d¨Ò¡C¥t¥~¡AÁÙ¯S§O´£¨Ñ¦³ÃöÃö³s¦¡¸ê®Æ®w¥H¤Î«Ø¥ßSQL±Ôzªº«ü¤Þ¡A¥H¤Î¦p¦ó¨Ï¥ÎVisual Basicµo®iSQL ServerÀ³¥Îµ{¦¡¡C¦b¥»®Ñ¤¤¡A§A¥i¥H¾Ç¨ì¡G Ãö©ó¨Ï¥Î M..... ..... ..... ..... ¥»®Ñ¬O§A·Ç³Æ·L³nÀË©w¦Ò¸Õ70-029¡GDesigning and Implementing Databases With Microsoft SQL Server7.0³Ì¨Îªº°Ñ¦Ò®ÑÂÇ¡A³o¥»¸g¹L·L³n»{ÃÒªº±M·~¬ãŪ«ü«n²[»\¤F¡G ©Ò¦³ªºÀË©w¥Ø¼Ð ³\¦h´I¦³¬D¾Ô©Êªº½Æ²ß°ÝÃD ¦b²{¹êÀô¹Ò¤º³]p»P¹ê§@SQL Server¸ê®Æ®wªº¤@¨Ç¹ê¥Î¸ê°T..... ¤º®e§¹¾ã¡B¸Ñ»¡¸Ô²Ó¡G¥»®Ñ¤¤¹ï©ó¸ê¾ãÓ¸ê®Æ®w¨t²Î¡BÃö³s¦¡¼Ò«¬¡BSQLªº»yªk»PÀ³¥Î¥H¤ÎSQL¬ÛÃö³nÅéÀ³¥Î¡A§¡¦³²M·¡ªº©w¸q¡B¸Ô²Óªº¤¶²Ð¡AÅýŪªÌªº¾Ç²ß§ó¤ã¹ê¡C ²z½×¹ê§@¨Ã«¡B§ó¯àÆF¬¡¹B¥Î¡G¥»®Ñ¤¤°£¤F¹ï¦U¶µ¨t²Î¦³²M·¡ªº©w¸q»¡©ú¥~¡A§óÁ|¥Îû¤uÁ~¸êªí¡B¾Ç¥Í¦¨ÁZªí¡B³q°T¸ô¡Kµ¥¦U¶µ¹ê¨Ò©M²z½×¬Û¤¬¬MÃÒ¡AÅýŪªÌÃö©À§ó²M´·¡A§ó¯à¯u¥¿ÆF¬¡¹B¥ÎSQL¡C ¹Ï¸Ñ¦¡»¡©ú¡B¸õÅD©Ê«ä¦Ò¡G¨C..... Microsoft ^¤å¬d¸ß DBCC ¸ê®Æ®w³W®æ¤@P©ÊÀˬd Transact-SQL¡BANSI SQL-92 Scripting SQL ¦w¥þ±±ºÞ SQL Server ¬d¸ß¤ÀªR¾¹ ¦p¦ó¥Î Mail¡BAlerts¡BJobs ¨ÓºûÅ@ SQL Database IJµo¦¡µ{§Ç¡B¹wÀx¦¡µ{§Ç¡BOLE §Q¥Î SQL-DMO ¼¶¼gµ{¦¡ ºûÅ@¨t²Îªºªí®æ»Pµ{§Ç¡BÂê©w¡B¥æ..... ¥»®Ñ¯S¦â¥»®Ñ¬OMicrosoft BackOffice®loch 4.5¥|¤j¸ê·½¤u¨ã¤§¤@¡A±z±N¥i¦b¥»®Ñ¤¤¾Ç¨ì¥H¤Uªº¤º®e¡G SQL Server 7.0ªº¬[ºc»P¤¸¥ó ¦³Ãö®e¶q¡B¸ê·½¤Î¶Ç²ÎÀ³¥Îµ{¦¡ªº³W¹º °w¹ï¸ê®ÆÜÀx¡B¦æ°ÊÀ³¥Î¤Î½u¤W¤ÀªR³B²z¨Ó³¡¸pSQL Server¸Ñ¨M¤è®× ¾E²¾»P¤É¯Åªº¦Ò¶q«ÂI µ{¦¡ªº«Ø¸m ¯Á¤Þªº½Õ¾ã ºÃÃø±Æ¸Ñ ¨aÃø´_ì..... ..... ..... ..... ¥»®Ñ¥Hªì¦¸¨Ï¥ÎSQL Server 7.0ªºÅªªÌ¬°¶D¨D¡Aº¥ý¤¶²Ð¸ê®Æ®w°ò¥»·§©À»PÃöÁp¦¡¸ê®Æ®wªº³W¹º§Þ¥©¡A§Y¨Ï¹ï¸ê®Æ®w¤£¼ô±xªºÅªªÌ¤]¯à«Ü§Ö¶i¤Jª¬ªp¡C±µµÛ°w¹ï¸ê®Æ®wªº«Øºc¤ÎSQL»yªk¶i¦æ¸Ñ»¡¤Î¥Ü½d¡AÅýŪªÌ¥R¥÷´x´¤SQL Serverªº³]pºëÅè¡A»´ÃP«Ø¥ß¡BÀ³¥Î¸ê®Æ®w¨t²Î¡C ¥t¥~¡A¦b«Ø¥ß¸ê®Æ®w¡B¸ê®Æªí¡BÃöÁp¡BViewB¯Á¤Þµ¥ª«¥ó®É¡A°£¤F¥i¥ÎSQL»yªk.....
¤½¤åºÞ²z¨t²Î 8±q SQL Server 7.0 ªº°ò¥»¬[ºc¶}©l¡A¸Ô²Ó¤¶²Ð SQL Server 7.0 ªº¦w¸Ë³W¹º¡B¸ê®Æ®wªº«Ø¥ß»P³W¹º¡B¦w¥þ©ÊºÞ²z¡B³Æ¥÷»P½Æ»s¡B¦øªA¾¹³Ì¨Î¤Æµ¥¦U¶µºÞ²zªÌ©Ò»Ý±¹ïªº¤u§@©MijÃD¡C¦¹¥~¡A®Ñ¤¤¤]¤¶²Ð¤F¸ê®ÆÜÀxªº¬ÛÃö¤º®e¡A¥]¬A¸ê®ÆÜÀxªº·§©À¡B¦p¦ó§Q¥ÎSQL Server 7.0¨Ó¹ê§@¸ê®ÆÜÀx..µ¥¹ê¥Î¤º®e¡C ¥»®Ñ¾A¦X¤w·|¨Ï¥Î SQL S..... ¥úºÐ¤º®e¡GMicrosoft SQL Server 7.0 120¤Ñ¥¿¦¡µû¦ôª© Microsoft SQL Server 7.0 ¸ê®Æ®w¤¸¥óService Pack 1 Microsoft SQL Server 7.0 OLAP Services Service Pack 1 ®Ñ¤¤½d¨Òµ{¦¡»P½d¨Ò¸ê®Æ®w ¤º®e²¤¶¡G¥»®Ñ¥úºÐ¤º§tMicr..... ..... ..... ..... ¥H¹ê¥Î¹ê§@¬°¥D¡A¥ô¦óªº¾Þ§@¨BÆJ¬Ò§¹¾ã¤¶²Ð¡Aµ´¤£§t½k±a¹L¡C ¥»®Ñ¯S§O«µøSQL Server 7.0¸ê®Æ®w²z½×ªº²`«×±´¯Á¡A¥H¤Î¸Ô²Óªº¹ê°ÈÀ³¥Î¡C §¹¥þ¥H¾Ç²ßªÌªº¨¤«×¨Ó¼¶¼g¡A¥þ³¡¤º®e±Ä¥ÎStep by Step¡]¨BÆJ¦¡¡^ªº¤è¦¡Á¿¸Ñ¡A¬ð¯}¾Ç²ßªÌ¾Ç²ßSQL Server¸ê®Æ®w¨t²Îªºª¼ÂIAµ´¹ï¹Ï¤å¨ÃZ¡AµL¥ô¦ó¾Ç²ß»Ùê¡C ¸Ô²ÓåªRSQL Server 7.0ªº¦UºØ¸ê..... ..... ¨C³¹¥H¶}©l¤§«e¶}©l¡AÅý±z¥ý¹ï§¹¦¨¦¹³¹°µ¦n·Ç³Æ¡C ¥un¦³¥i¯à¡A¨CÓ½Òµ{¤¤³£·|¥]§t¥iµ¹±z¾÷·|¨Ï¥Î³Q®i²{¹Lªº§Þ¥©©Î±´°Q´¿¸g´yz¹LªºÀ³¥Îµ{¦¡ªºµ{§Ç¡C©Ò¦³µ{§Ç¬O¥H¦b¦¹¬q¸¨¥ª¤èªº¶µ¥Ø²Å¸¹¨Ó¼Ð©úªº¡C..... ¥HVisual Basic¬°«eºÝ·f°t«áºÝSQL Server¸ê®Æ®w¦øªA¾¹¡A¤@ª½¬O¥D±q¬[ºc¦s¨úÀ³¥Î¤W¬Û·í«nªº²Õ¦X¡C¥»®Ñ¯S¦â§YµÛ«¦b¨â®M³nÅ骺¾ã¦X§Þ¥©¡AÀ³¥Î½dÃ¥«h¥]§t¤@¯ë¸ê®ÆºûÅ@»PIntranet/Internet¸ê®Æªº¦s¨ú§@·~¡C½×zªº¥DÃD¤À§O¦C¥Ü¦p¤U¡G ¸ê®Æ®wªº«Ø¸m»PºûÅ@ ¤¶²Ð¥D±q¬[ºc¨t²Î³W¹º¥HSQL Server 6.5/7.0¸ê®Æ®wªº«Ø¸m»PºûÅ@..... ..... ..... ¥»®Ñ°£¤F¸Ô²Ó¤¶²Ð¦p¦ó¨Ï¥Î»PºÞ²zSQL Server 7.0¨t²Î¤§¥~¡A§@ªÌÁÙºë¤ß³]p¤F¤@¥Ü½d¸ê®Æ®w¡C¸Ó¥Ü½d¸ê®Æ®w¤¤°£¤F¦³¥Ü½dªº¸ê®Æ¥~¡A¹ï©ó¦p¦ó¸g¹L¥¿³W¤Æªº¤âÄò¨Ó³]p¸ê®Æ®w¤]¦³¸ÔºÉªº»¡©ú¡C¦b¦U³¹¸`¤¤§@ªÌ³]p¤F³\¦hªº½d¨Ò»P½m²ß¨Ãªþ¦³¸Ñµª¡A¨ä¥Øªº¬O§Æ±æÅªªÌ¥i¥Hªá¶O³Ì¤Öªº®É¶¡¨Ó¼ô±x¸ê®Æ®wªº³]p»PSQL Server 7.0ªº¾Þ§@¡C ..... ¡½ ³W«h (rule)¡B¨î (constraint)¡B¥H¤Î¹w³] (default)¡½ ¹wÀxµ{§Ç (stored procedure)¡½ ¬yµ{±±¨î±Ôz¡½ IJµo (triggerr)¡½ ³]p¬d¸ß (query) ¿ï¶µ¡½ ¸ê®Æ®w½Æ»s (replication)¡½ DTC (Distributed Transaction Coordinator)¡½ SQL S..... ..... ùþ SQL Server²¤¶ùþ SQL Server 7.0·s¥¯à²¤¶ù?Windows NT²¤¶ùþ ¸ê®Æ®w°ò¥»·§©Àùþ SQL Server©M¤u¨ãµ{¦¡ªº¦w¸Ë©M³]©wùþ ¦h¼h¦¡¡]Multi-Tier¡^¬[ºc¨t²Îùþ ¸ê®Æ®w¡Bªí®æ¤Î¥æ©ö°O¿ýùþ Transact-SQLùþ ªí®æ¸ê®Æªº·s¼W¡B²¾°£¤Î×§ïùþ À˵ø¡]View¡^ùþ ¯Á¤Þ¤ÎÁä¡]Key¡^ùþ ¥æ©ö¡]Transacti..... ¥»®Ñ¥H´`§Çº¥¶iªº¤è¦¡¤¶²ÐSQL Server 7¡A±q¦w¸ËSQL Server¡B¸ê®Æ®w¸Ë¸m¨ì¸ê®Æ®wª«¥óªº«Ø¥ßºÞ²z(¥]§t¤Fªí®æ¡BIJµo¾¹¡K)¡A¶i¦Ó¤¶²Ð§ó²`¤Jªº¦w¥þ»{µý¡B¸ê®Æ®w³Æ¥÷µ¥¡A±q¦w¸Ë¨ìÀ³¥Î³£¸Ô¹ê¤¶²Ð¡AÅý±z§Ö³t¾Ç²ß¡A»´ÃPºë³qSQL Server 7¡C..... ..... ¥»®Ñ¬OMicrosoft BackOffice(tm) Resource Kit¸ê·½¤u¨ã¤â¥Uªº¨t¦C±Ð§÷¤§¤@¡C¦b³o¥»®Ñ¸Ì±¡A§A¥i¥H§ä¨ì¥]ù¸U¶Hªº¸ê°T¡A¥]¬A¡G ÁA¸ÑMicrosoft SQL Serverªº¬[ºc ¤É¯Å¦ÜMicrosoft SQL Server 6.5©Î§ó·sª©¥»ª÷ ³Wµe»P§G¸pMicrosoft SQL Serverªº¹ê°È°ÝÃD»P¸Ñ¨M¤§¹D ¨ÏMic.....
¤½¤åºÞ²z¨t²Î 9³o¬O¤@¥»¥ÑMicrosoft»{¥iªº»{ÃÒ«ü¾É¤â¥U¡A¤º®e§t»\¤F³q¹LSQL SERVER 6.5 DESIGN & IMPLEMENTATION »{ÃÒ©ÒÀ³¸Óª¾¹Dªº¤@¤Á¡AÅý§A±q¥Í¤âÅܦ¨±M®a¡CMCSE»{ÃÒ«ü¾É¤â¥U-SQL SERVER 6.5 DESIGN & IMPLEMENTATION§¹¾ãªº¤º®e¥]§t¤F¦Ò¸Õ©Ò¦³¥DÃD¥]¬A¡G¸ê®Æ¼Ò¦¡ ( Data Modeling ..... Microsoft©Ò»{¥iªººô¸ô±M·~±Ð§÷TestPrep¥]¬A70-26¸ÕÃDMicrosoft Certified Professional©Ò»{¥iªº±Ð§÷CD-ROM¥]¬A¿W¤@µL¤GªºTestPrep¼ÒÀÀ¸ÕÃD¡E¥]§t±z¥²»Ýºë³qªº§Þ³N¤Î³q¹L¦Ò¸Õªº©Ò¦³¸ê°T¡E³z¹L¨C³¹ªº´úÅç±z¯à¤F¸Ñ¨Ã´£¤É¦Û¤vªº¹ê¤O¡E¿W¤@µL¤GªºTestPrep¼ÒÀÀ¯u¥¿ªº¦Ò¸ÕMCSE°V½m¤â¥U--SQL SER..... ¡m·L³nSQL¦øªA¾¹±´¯¦¡n¬O¦P®É°w¹ï¸gÅçÂ×´Iªº¸ê®Æ®wºÞ²zû©Mªì¾ÇªÌ©Ò¼gªº¡C¥¦¤À¦¨¨âÓ³¡¤Àªº³¹¸`¯à°÷À°§UºÞ²z§ä¥X¤ÎÁA¸Ñ¥L̲¶·ª¾¹Dªº¡C¨C¤@³¹ªº²Ä¤@³¡¤À´£¨ÑÁA¸Ñ¸Ó¥DÃD©Òªº¸Ô²ÓI´º¸ê®Æ¡M¥H¤Î¤j¶qªº¹ê¥Î¸ê°T¡M±z¥i¥H±N³o¨Ç¸ê°T¹B¥Î¨ì¥Í²£Àô¹Òªº·L³nSQL¦øªA¾¹¹q¸£¤W¥H¸`¬Ù±zªº®É¶¡©M·Ð´o¡C¨C¤@³¹ªº¹ê¥Î«ü«n³¡¤À«h¤@¨B¤@¨B¦a»¡©ú¦p¦ó¹ê»Ú§¹¦¨¨º¤@³¹©Ò°Q½×ªº¥DÃD¡C ¥»..... ..... ..... ³Ì§¹¾ãªºSQL Server¨Ï¥Î°Ñ¦Ò¤â¥U¡ESQL Server¸ê®Æ®w©MWebªº³s±µ¡E¦p¦ó±NAccess¸ê®Æ®w²¾´Ó¨ìSQL Server¤W¡Eºë³qSQL Serverªº³W«h¡BIJµo¤ÎÀx¦s¨ç¼Æ¡E¦p¦ó¶i¦æ¸ê®Æ®wªº½Æ»s¡E¦p¦ó§Q¥ÎSQL Server¶}µo¥D±q¦¡µ{¦¡¦p¦ó±NOffice 97 ¾ã¦X¨ìSQL Server¤¤SQL Serverªº¦w¥þ±¹¬I¥þ²y¾P°â¶q²Ä¤@¦W¡I¥[¤J..... ³Ì§¹¾ãªºSQL Server¨Ï¥Î°Ñ¦Ò¤â¥U¡E¦p¦ó¦w¸ËSQL Server¡E¸ê®Æ¼Ò«¬¤Î¥D±q¦¡¬[ºc¨t²Î¡E¦ó¿×¸Ë¸m¡B¸ê®Æ®w¡Bªí®æ¤Î¥æ©ö°O¿ý¡E¦ó¿×Transact-SQL¡E¦ó¿×À˵ø¡BÁä¡B¯Á¤Þ¤ÎÂê©w¦p¦ó¨Ï¥ÎSQL¤º«Ø¨ç¼Æ¥þ²y¾P°â¶q²Ä¤@¦W¡I¤ºªþ¥úºÐ¥þ¥@¬É³Ì¨üÅwªïªº¸ê®Æ®w³nÅ骺³Ì¨Î°Ñ¦Ò®ÑÅý§A§¹¥þµo´§SQL Serverªº©Ò¦³¥\¯à ¡V ¹ê²{¸ê°T««¤â¥i±oªº¹Ò¬É¥»®Ñ¬OQue/..... ..... ..... ..... ..... ..... ..... .....
¤½¤åºÞ²z¨t²Î 10¥»®Ñ¯S¦â PostgreSQL¬O¤@®M§¹¥þ§K¶O¦Ó¥BOpen Sourceªº (ORDBMS) ª«¥óÃöÁp¦¡¸ê®Æ®wºÞ²z¨t²Î¡A±q1986¦~¦Ü¤µ¤]¤w¸g¤Q´X¦~¤F¡C¥Ñ©óInternetªºµo®i§Ö³t¤ÎOpen Sourceªº·§©À¡A±a°Ê¤FPostgreSQLªº§Ö³tºt¶i¡A¥Ø«e¤w¦³¼s¤jªº¨Ï¥Î±Ú¸s¡A¥¦ªº¥\¯à©M¨ä¥¦«D°Ó·~©Ê¸ê®Æ®w¬Û¤ñ¸û¡A¦³¹L¤§¦ÓµL¤£¤Î¡A¦Ó¥B¥i«Ø¸m©ó¦hºØ¥¥x¡B¤ä´©¸ê.....§ó¦h ŪªÌ¥i¥HÂǵۥ»®Ñ¼sªxªº¸ê·½¡A¶}µo±j©TªºSQL Server 2000¸ê®Æ®w©M¸ê®Æ®wÀ³¥Îµ{¦¡¡C¥»®Ñ¸ÑÄÀ¦p¦ó¨Ï¥ÎTransact-SQL¦s¨ú©M¾Þ§@¸ê®Æ¡A«Ø¥ß¥\¯à±j¤j¡B¨ãADO¡BDAO¡BDBCDirect¡BODBC©MRDOªºWindowsÀ³¥Îµ{¦¡¡A¨Ã¥B¶}µo¾ã¦X¡B¸ó¥¥x¡B¨ãASP©MXMLªºWebÀ³¥Îµ{¦¡¡C¦¹¥~¡AŪªÌ¤]¥i¥HÀò±oSQL Server 2000ºÞ.....§ó¦h ¸ÔºÉ¸Ñ»¡DTS«Ê¸Ëªº¦U¶µ²Õ¦¨¤¸¯À»PDTS¤u§@¡A«OÃÒ¥´¤U¤ã¹ê®Ú°ò¡C ·f°t½d¨Ò¤¶²Ð´M¬d¬d¸ß¡B¸ê®Æ¾É¦V¬d¸ß¡B»P¦UÃþ«¬Äæ¦ìÂà´«§@·~¡A§U±z«Ø¥ß¥¿½T¨Ï¥ÎÆ[©À¡C ¦h¶¥¬q¸ê®ÆÀ°®ú¹ý©³¬ã¨s¡C ²Ó»¡¦p¦ó¨Ï¥ÎActiveX Script¨Ó¦ÛqÂà´«§@·~¡B¦s¨úADO¸ê®Æ¿ý¶°¡B»P¨Ï¥ÎÀɮרt²Îª«¥ó¡C °ÊºAÄݩʤu§@¹ý©³¬ã¨s¡C »¡©ú¦p¦ó¨Ï¥ÎDTS¨Ó³B²zAnaly.....§ó¦h ..... ..... ²©ú©öÀ´-§Y¨Ï¬O±q¥¼±µÄ²¹LSQLªºÅªªÌ¤]¯à«ö³¡´N¯Z¨Ó¾Ç²ß¡C ÝÅU²z½×»P¹ê§@-¥»®Ñ¤£»´©¿°ò¦·§©Àªº«n©Ê¡A¨Ã«¹ê§@»P²z½×¡C Ý«³W®æ»P²£«~-¥»®Ñ¥HSQL-92¬°·Ç¡A¦P®É¦Ò¶q¨ìOracle¡BSQL Server¡BAccessµ¥²£«~ªº¹ê»Ú±¡§Î¡C.....§ó¦h ¨Ï¥Î¹w¦sµ{§Ç¨Ó¼¶¼g¨ã¦³¼u©Ê¡B¦Ó¥B®Ä²v·¥°ªªºSQL ServerÀ³¥Îµ{¦¡¡C¥»®Ñ¡mSQL Server 2000¹w¦sµ{§Çµ{¦¡³]p¡n±N§i¶D§A¦p¦ó¨Ï¥ÎTransact-SQL¨Ó³]p¡B°£¿ù©MºÞ²z¦Ûqªº¹w¦sµ{§Ç¡B¨ç¼Æ¡B¥H¤ÎIJµoµ{§Ç¡C§A±N·|¾Ç¨ì¡G¨Ï¥ÎEnterprise Manager¡BQuery Analyzer¡BVisual Basic¡B©MVisual St.....§ó¦h ¥»®Ñ¬°¹q¤l°Ó°ÈÀ³¥Î³nÅ骺¸ê®Æ®w´£¨Ñ¤@Ө㩵®i©Ê¡B«½Æ©Ê¤Î¥i¾a©Êªº°ò¦¡A¥]§t¦w¸Ë¡B½Õ¾ã¡B¨t²Î¬[³]¡B¦w¥þ¾÷¨î¡BÀɮ׺޲z¡B¸ê®Æ¾Þ§@¡B½Æ¼g¡B¦Û°Ê¤Æ¥H¤Î³Æ¥÷ÁÙì¡C¨ä¤¤¥]§t¦³³Ì·sªº¸ê°T¡B¹ê¨Ò¤Î¹ê¥Îªº¸Ñ¨M¤è®×¡C¨Ã±q¹ê°È¸gÅç¤@¸`¤¤¡AÂI¥X¤@¨Ç§@ªÌ¦bSQL ServerºÞ²z¸gÅç¤Wªº§Þ¥©¡C¥»®Ñ¬°SQL Server DBA̤£¥i©Î¯Êªº«n¸ê·½¡C ³]©w¡B½Õ®Õ©MºûÅ@SQL .....§ó¦h
¤½¤åºÞ²z¨t²Î 11..... ..... Easily Manage Your SQL Server¡M AnyTime¡M AnyWhere! Åý±zÀH®ÉÀH¦a³£¥i¥H»´ÃP´x±±SQL Server 2000! ¥»®Ñ«ÂI µ½¥ÎSQL ServerªºµøÄ±¤ÆºÞ²z¤u¨ã-Enterprise Manager¡A»´ÃP¾r¶¿»P¾ã¦X±z´xºÞªºSQL Server ¦h¥xSQL ServerªººÞ²z ¦p¦ó±q»·ºÝ¨ÓºÞ²z.....§ó¦h Àò±o±zªº¶i¯Å§Þ¥© ¶È¶È¦b21¤Ñ¤º¡A±z´N·|¨ã³Æ©Ò¦³¤É¯Å¥H¤Î¯à°÷°ª®Ä²v¾Þ§@©Ò»Ýnªº§Þ¥©¡C¦b³oÓ§¹¾ãªº±Ð¾Ç¤¤¡A±z±N´x´¤°ò¥»ª¾ÃÑ¡A¨Ã¶i¤@¨BÁA¸Ñ§ó¶i¶¥ªº¯S©Ê¤Î·§©À¡C ÁA¸ÑMicrosoft SQL Server 2000ªº°ò¥»ª¾ÃѨüô¥Î¨ä¥Dn¥\¯à ³z¹L½m²ß¤Î¹ê»Ú¨Ò¤l¡A¾Ç²ß°ª®Ä²v¦a¨Ï¥ÎSQL Server³Ì·s¤u¨ã¤Î¯S©Ê Àò±oSQL Server»â°ì¤ºªº»â¾ÉÅv«Â.....§ó¦h ¥»®Ñ¯S¦â¡G ¥»®Ñ¥]§tSQL Server 2000©ó©Ò¦³À³¥Î³nÅé¶}µo®É©Ò»Ýªº§Þ³N¡C ¥þ®Ñ©Ò´£¤Îªº§Þ³N¡A§¡¥H²M·¡ªº»¡©úÅý±z¨³³tÁA¸Ñ¡C ¥þ®Ñ»²¤§¥H¹Ï¸Ñ©M½d¨Ò¦¡ªºÁ¿¸Ñ¡AÅý±z¥i¥H¨ãÅé¦aÁA¸ÑSQLñ¸û²`¤J»P¶i¶¥ªº§Þ³N¤º®e ±Ð®v±Â½Ò¤j«K§Q¡G¬°¤F¥ô½Ò±Ð®v¤W½Ò¤è«K¡A¥»®Ñ©Ò¦³¤º¤å«T»s§@¦¨PDFÀÉ¡AÅý±Â½Ò±Ð®v¦Û¥Ñ¨Ï¥Î¡AÅý¦Ñ®v¥i¥H¦b¦³¼s¼½±Ð¾Çªº±Ð«Ç±Ð¾Ç¡A©Î»s§@¦¨§ë¼v¤ù¨Ó.....§ó¦h PostgreSQL´X¥G¥i¥Î©ó©Ò¦³Unix¥¥x¡B¨Ï¥Î§¹¥þ§K¶O¡Bµ{¦¡½X§¹¥þ¤½¶}¡B¤ä´©¸ê®Æ®w¼Ð·Ç»y¨¥SQL¡A¤w¸g¦¨¬°³Ì¥ý¶iªº¸ê®Æ®w¨t²Î¡C ¥»®Ñ¤¶²ÐPostgreSQLªº¦w¸Ë¡B¨Ï¥Î¤èªk¥~¡AÁٸѻ¡¦p¦ó¨Ï¥ÎTcl/Tk¡BC¡BPHP¡BPerl¡BJavaµ¥¦UºØµ{¦¡¤¶±»s§@À³¥Îµ{¦¡¤Î¨ä¥¦«n¬ÛÃö¸ê°T¡C±qÀ³¥Îµ{¦¡ªº¨Ï¥Î¤èªk¨ìì©l½Xªº¤º®eµ¥³£¥H¨ÒÃD¸Ô²Ó¸Ñ»¡¡AÅý§A¹ê.....§ó¦h ¥»®Ñ¤£¶È¹ï¸ê®Æ®wºÞ²z¨t²Î²z½×§@¦³¨t²Îªº¤¶²Ð¡A§@ªÌ¥©«ä¦w±Æ¤@¨t¦C´`§Çº¥¶iªº¹ê¥Î½d¨Ò¡A¹ê»Ú¤W¾÷¾Þ§@ÅýŪªÌ»´ÃP¾Ç·|SQL Server ¤¤µØ¹q«H¼Æ¾Ú¤À¤½¥qÁ`¤uµ{®v ¤ý¤å¤s ³o¬O¤@³¡¤º®e¸Ô¹ê¡A½d¨ÒÂ×´Iºë±m¹ê¥Î¡A¨Ã³v¨B¤Þ¾ÉŪªÌ¼ô±xSQL Server ±j¤jªº¥\¯à¡C¥»®Ñ¹ïŪªÌ·|·P¨ì¶VÃøÀ´ªº¦a¤è¡AÁ¿±o¶V²M·¡.....§ó¦h ²Ä¤@³¹ °ò¥»·§½×»P¥»®Ñ¾ÉÄý ²Ä¤G³¹ ¨t²Î«Ø¸m¶·ª¾ ²Ä¤T³¹ ¦øªA¾¹ºÞ²zªì¨B ²Ä¥|³¹ ¸ê®Æ®wªººÞ²z»PºûÅ@ ²Ä¤³¹ ¸ê®Æ®wª«¥óªººÞ²z ²Ä¤»³¹ ¸ê®ÆÂà´«ªA°È(DTS) ²Ä¤C³¹ ´x±±¸ê®Æ¥æ©ö(Transaction) ²Ä¤K³¹ Âê©w(Lock) ²Ä¤E³¹ ¸ê®Æ®wªº´_ì ²Ä¤Q³¹ ½Æ¼g(Replication) ²Ä¤Q¤@³¹ ¤u§@¦Û°Ê¤Æ ²Ä¤Q¤G³¹ ºÞ²z¦øªA¾¹¦w¥þ©Ê ²Ä¤Q¤T³¹.....§ó¦h
¤½¤åºÞ²z¨t²Î 12³o¬O¤@¥»¾A¦Xªì¾ÇªÌªºSQL Server 2000½d¨Ò®Ñ¡A¥á¶}¨º¨ÇÁ}Àߪº²z½×¡A¥»®Ñ´£¨Ñ¹ê¥Îªº½d¨Ò¡B²LÅã©öÀ´ªº¤å¦r»¡©ú¦A¥[¤W²³æªº¹Ï¤ù¡AÅý±z¥i¥H«Ü§Ö¹ïSQL Server 2000¦³¤@Ó¥þ±©Êªº¤F¸Ñ¡C.....§ó¦h §¹¥þ¹ê°È¾É¦V¡A¥HManagement.surpro.com¤½¥q¬°¨Ò¡A±q¦w¸ËSQL Server2000¨t²Î¡B¦w¸Ë°õ¦æÓÅé(Default Instance)¡B¸ê®Æ®wª«¥ó(Database Object )ªº«Ø¥ß¡BT-SQL»yªkªº¤¶²Ð¡B¹w¦sµ{§Ç(Stored Procedure )ªº¨Ï¥Î¡BSQL Server 2000¸ê®Æ®wªº³Æ¥÷(Backup)»P½Æ¥»(.....§ó¦h SQL Server 2000ª©¥»¹ï©óXMLªº¤ä´©¬O¤@¶µ«¤jªº§Þ³N²·s¡A¥»®Ñ¯S§O°w¹ïXMLªº»yªk§@¤F¤@µf¤ÀªR¡A¦P®É¤]¥H¹ê§@¤è¦¡¡A¸Ô²Ó¤¶²Ð¦p¦ó¦bSQL Server¤º¨Ï¥ÎXMLªº§Þ³N¡C ¥»®Ñ¯S§O°w¹ïMicrosoft.NET Enterprise Server¤¤ªº¦U¶µ²Õ¦¨ªº¦øªA¾¹¡A§@¤Fªì¨B¤¶²Ð¡A¨Ã¥B°Q½×¨ì¥¼¨ÓMicrosoft¦b.NET¥¥x¤Wªºµ¦²¤µo®i¡A.....§ó¦h ¥»®Ñ¯S¦â¡G ´`§Çº¥¶i¤è¦¡¾Ç²ßSQL Server 2000¡C ±j½Õ²z©À»P¹ê°È°t¦X¡A°t¦X§¹¾ãªº¬[ºc¹Ï»P¹Ï¸Ñ¡BÀ³¥Îµ{§ÇÅý±z»´ÃP¶i¤JSQL Server 2000½dÃ¥¡C ±qµøÄ±¤Æ¦Ü«ü¥OÀ³¥Î¡A±q«Ø¸m¨ì°ò¥»ºÞ²z¡AÅý±zÁA¸ÑSQL ServerºëµØ©Ò¦b¡C ¥»®ÑªþÃØ¡GSQL Server 2000 120µû¦ôª©.....§ó¦h ..... ..... §@ªÌ±q¸ê®ÆÜÀxªº·§©ÀµÛ¤â¡M»¡©úOLAP¤ÀªR¸ê®Æ®wªº«Ø¸m¡M¥Ñ²L¤J²`ªº±a»â¨Ï¥ÎªÌ«Ø¥ß¤ÀªRªºCube»P¸ê®Æ±ÄÂ^¼Ò«¬¡M¨Ã»¡©ú¦p¦ó³z¹L«eºÝªº¸ê®Æ¤ÀªR¤u¨ã¦pExcel©ÎWeb¨Ó¨ú±o¤ÀªRµ²ªG¡MÅý¥ø·~¥D¤£¦ý¥i¥H¥Î³Ì¤Öªº®É¶¡¡M³B²z¨Mµ¦¤ÀªR©Ò»Ýªº¸ê®Æ¡M¨Ã±q¤¤±o¨ì¦UºØ¤£¦Pªº¤ÀªRµ²ªG¡M§@¬°¸gÀç¨Mµ¦ªº°Ñ¦Ò.....§ó¦h ¤¶²Ð¸ê®Æ®wªº°ò¥»·§©À»PÃöÁp¦¡¸ê®Æ®wªº³W¹º§Þ¥©¡A§Y¨Ï¹ï¸ê®Æ®w¤£¼ô±xªºÅªªÌ¤]¯à°÷«Ü§Ö¶i¤Jª¬ªp¡C±µµÛ°w¹ï¸ê®Æ®wªº«Øºc¤ÎSQL»yªk®i¶}´`§Çº¥¶iªº¸Ñ»¡¤Î¥Ü½d¡AÅýŪªÌ¥R¥÷´x´¤SQL Serverªº³]pºëÅè¡A»´ÃP«Ø¥ß©Ò»Ýªº¸ê®Æ®w¨t²Î¨Ãµ½¥[À³¥Î¡C ¥t¥~¡A¦b«Ø¥ß¸ê®Æ®w¡B¸ê®Æªí¡BÃöÁp¡BÀ˵øªí¡B¯Á¤Þµ¥ª«¥ó®É¡A°£¤F¥i¥H¨Ï¥ÎSQL»yªk¨Ó¾Þ§@¥~¡ASQL Server 20.....§ó¦h
¤½¤åºÞ²z¨t²Î 13¥»®Ñ¯S¦â¡G SQL Server 2000 «Ø¸m»PºÞ²z¤â¥UµÛ«¦bSQL Server 2000ªº¸ê®Æ®w«Ø¸m»PÀ³¥Î¼h±¡A±q¸ê®Æ®w¨t²Î«Ø¸m¡B¦UºØ¸ê®Æ®wª«¥óªº«Ø¸m§Þ¥©¡A©µ®i¦Ü«eºÝÀ³¥Îµ{¦¡©ÎWebÀ³¥Î¨t²Îµ¥¦U¶µ±M®×ªº¶}µo¡A³£¦³¹d²ÓÃû¿òªº²`¤J¤¶²Ð¡AÅý±z¥i¥H´`§Çº¥¶iªº»{ÃѨì¡¥ÎSQL Server 2000³oÓ¸ê®Æ®w¥¥x¡AÅýSQL Server 2000¦¨¬°.....§ó¦h .....§ó¦h ¥»®Ñ¥H²`¤J²L¥Xªº¤¶²ÐSQL Server 2000»PAccess 2000ªº·f°t§@·~¬°¥Øªº¡A¥ÑSQL¸ê®Æ®wªº«Ø¥ß¡BSQL Server¨C¤@Ó¤u¨ãªº¨Ï¥Î¤èªk¡B²©öªºSQL»y¨¥¸Ñ»¡¶}©l¡A±µµÛ¶i¤J¨Ï¥ÎSQL Server©M Access¨Ó¬[³]¤@Ó¥D±q¦¡¬[ºcªº¨t²Î¡A¨ä¤¤¹ï¦øªA¾¹ªº·s¦s¨ú¤è¦¡¢w§Yªñ¨Ó¿¨üª`¥ØªºADO³o¤@¤è±¡A§ó¬Oªá¤F¬Û·í¦hªº½g´T°µ¤F¸ÔºÉªº¤¶²Ð.....§ó¦h ¥»®Ñ¥H´`§Çº¥¶iªº¤è¦¡¨Ó¤¶²ÐSQL Server¡A±q¦w¸Ë©M°ò¥»·§½×°_¦Ü¸ê®Æ®wª«¥ó(¸ê®Æªí¡AÀ˵ø¡AIJµoµ{§Ç...)ªº«Ø¥ß©M¨Ï¥Î¡C ¥t¥~¤]¤¶²Ð¤FSQL Serverªº¨t²ÎºÞ²z¦p¦w¥þ»{µý¡B³Æ¥÷¡B½Æ¼gµ¥¡A¤ÎSQL Server©Ò´£¨Ñªº¤@¨Ç¤u¨ã¦p¡G¸ê®Æ²¾Âà¤u¨ã(DTS)¡BAnalysis Services(OLAP)¡BQuery Analyzerµ¥¡A¨Ã¹ï©ó.....§ó¦h ..... ..... ¤¶²Ð¦p¦ó¦w¸ËSQL Server 2000 ±Ä¥Î´`§Çº¥¶i¤è¤@¦¡¡A¤¶²Ð¦p¦ó«Ø¥ßSQL Server¸ê®Æ®w»P¨ä¤¤ªº¦UºØª«¥ó¡A±Ä¥Î½d¨Ò¾É¤Þ¤è¦¡Åý±z»´ÃP¶i¤JSQL Server¸ê®Æ®w¦øªA¾¹»â°ì¡A±j½ÕµøÄ±¤Æ¤u¨ã»P«ü¥O¬Û¦VÀ³¥Î¡A§¹¥þ¤¶²ÐSQL Server2000·s¼W¯S©Ê¡A¨Ã¥B¤¶²Ð¦p¦ó«Ø¸m¤@Ӥ䴩XMLªº¸ê®Æ®w¡C ¤¶²Ð¦p¦ó¦w¸ËSQL Server 2000 ¡A.....§ó¦h .....
¤½¤åºÞ²z¨t²Î 14¦b¥»®Ñ¤¤¡A§ÚÌ´`§Ç¦a¨Ó¤¶²ÐSQL Server 2000¦b¸ê®Æ®w³]p¡B¸ê®Æ®wªººÞ²z¡BÀ˵øªí¡B¯Á¤Þµ¥¤è±³£´£¨Ñ¤F¸Ô²Óªº»¡©ú¡AÅý±z¥i¥H¥R¤À¦a¤F¸ÑSQL Server 2000¦b³]p¤è±ªº¥\¯à¡A¨Ã´£¨Ñ½d¨Ò¯àÅý±z¦b¾Ç²ßªº¹Lµ{¤¤¯à°÷§ó»´ÃP´x´¤SQL Server 2000¡C.....§ó¦h ¥»®Ñ¾A¦X¥Ø«e¾á¥ôSQL SEVER7ªº°ò¦®ÑÄy¡A§Ú̲[»\³\¦hDBA ªº»â°ì¡A¦ý§Ṳ́]§R¥h¤FDBAªº¤@¨Ç°ò¥»ª¾ÃÑ¡A¹³¬OMIDDLE TIER«eºÝµ{¦¡³]p¤§¬y¡A§Ú̧怜¿ý§ó¬°²`¤JªºÄ³ÃD¡A¹³¬OMTS¡BSQL-DMO©M¥þ²y¸ê°Tºôµ¥µ¥¡C §Ṵ́²³]ŪªÌ¦bINTEL ¥¥x¤W°õ¦æSQL SEVER7ªº¼Ð·Çª©¡AYŪªÌªº°õ¦æ¥¥x¤£¦P¡A¨º»òŪªÌ©Î³\·|¬Ý¨ì¤@¨Ç¥Dn®t²§.....§ó¦h SQL Server 2000¬O·L³n¸ê®Æ®w¨t²Îªº¥Nªí§@¡A§ó¬O¤½¥q»P¥ø·~¥Î¨Ó«Ø¥ß¦UºØ°Ó·~À³¥Îµ{¦¡ªº³Ì¨ÎÃöÁp¦¡¸ê®Æ®w¡C°£¤FªÃ«ù©ö¾Ç¡B©ö¥Îªº©v¦®¥~¡A§ó¥[±j¤FÂX¥R©Ê¡B¥i¾a©Ê¡B°õ¦æ®Ä¯à¥H¤Î¸ê®Æ¤ÀªRµ¥¯à¤O¡A¥i»¡¬O¸ê®Æ®w¨t²Îªº³Ì¨Î¿ï¾Ü¡C¥»®Ñ°£¤F¸Ô²Ó¤¶²Ð¦p¦ó¨Ï¥Î»PºÞ²zSQL Server 2000¨t²Î¤§¥~¡A§@ªÌÁÙºë¤ß³]p¤F¤@¥Ü½d¸ê®Æ®w¡C¸Ó¥Ü½d¸ê®Æ®w¤¤°£¤F¦³¥Ü½dªº¸ê.....§ó¦h ¡i¤º®e¤¶²Ð¡j ±q SQL Server 2000 ªº°ò¥»¬[ºc¶}©l¡A¸Ô²Ó¤¶²Ð SQL Server 2000 ªº¦w¸Ë³W¹º¡B¸ê®Æ®wªº«Ø¥ß»P³W¹º¡B¦w¥þ©ÊºÞ²z¡B³Æ¥÷»P½Æ»s¡B¦øªA¾¹³Ì¨Î¤Æµ¥¦U¶µºÞ²zªÌ©Ò»Ý±¹ïªº¤u§@©MijÃD¡C¦¹¥~¤]¤¶²Ð¤F¸ê®ÆÜÀx¤Î¸ê®Æ±ÄÂ^ (Data Mining) ªº¬ÛÃö¤º®e¡A±q°ò¥»ªº¸ê®Æ¡BÜÀxªº·§©À¡BSQL Server 2000 ¹ê§@¸ê®ÆÜÀx¡B.....§ó¦h ¥Ñ¥xÆW·L³n±M·~Á¿®v¤ÎÅU°Ý°õµ§¡B¥ø¹º¡C ¨t²Î¤Æ¦a¤¶²ÐMicrosoft(r) SQL Server(tm) 2000¤¤¤åª©ªº¾ãÅé¬[ºc¡A¬°¤é«á¾Ç²ß³þ¤U¨}¦n®Ú°ò¡C «ü¾É±z¦p¦ó«Ø¸m°ª«~½è»P§¹µ½ªº¸ê®Æ®w¡C ²Ó»¡¦p¦óºc«Ø¸ê®Æªí»P±ø¥ó¬ù§ô¡A¥H½T«O¸ê®Æªº§¹¾ã©Ê¡C ²Ó»¡¦p¦óµ½¥Î¯Á¤Þ¨Ó´£ª@®Ä²v¡C ¬d¸ß¡B¶×¾ã¡B²Îp¡B»P¤ÀªR¸ê®Æ¬O¤@¤Á¸ê®Æ¦s¨ú§@·~ªº°ò¦¡A¥»®Ñ¬°±z²Ó»¡±qÀY¡C ¸Ô.....§ó¦h ..... §@ªÌ²¤¶ Divya Chaturvedi ¼w¦{¥ð¤h¹yªºº®uSQL Server±M®a¡A¦o¾á¥ô¤½¥q¥ø·~¤§SQL ServerÅU°Ý¡A¨Ã³]p¡B¬[³]¤ÎºûרϥÎSQL Serverªº¤j«¬¨t²Î¡A¦b1991¦~SQL Server¶}©lÀ³¥Î®É¡A¸Ó¤½¥q¬O¬ü°ê°ê¤º¥Dnªº¸ê°TªA°È¤½¥q¡C Divyaªº¶l¥ó«H½c¡Gdchaturvedi@norrellis.com P.....§ó¦h ¥»®Ñ¤£¶È¹ï¸ê®Æ®wºÞ²z¨t²Î²z½×§@¦³¨t²Îªº ¤¶²Ð¡A§@ªÌ¥©«ä¦w±Æ¤@¨t¦C´`§Çº¥¶iªº¹ê¥Î ½d¨Ò¡A¹ê»Ú¤W¾÷¾Þ§@ÅýŪªÌ»´ÃP¾Ç·|SQL Server¡]¤¤µØ¹q«H¼Æ¾Ú¤À¤½¥qÁ`¤uµ{®v ¤ý¤å¤s¡^ ³o¬O¤@³¡¤º®e¸Ô¹ê¡A½d¨ÒÂ×´Iºë±m¹ê¥Î¡A¨Ã ³v¨B¤Þ¾ÉŪªÌ¼ô±xSQL Server ±j¤jªº¥\¯à¡C ¥»®Ñ¹ïŪªÌ·|·P¨ì¶VÃøÀ´ªº¦a¤è¡AÁ¿±o¶V²M ·¡¡A¯u¬O¤@³¡¥O¤H¿E½àªº§¹¾ã¸ê®Æ®w±Ð¬ì®Ñ ݤu¨ã®Ñ¦b.....§ó¦h
¤½¤åºÞ²z¨t²Î 15..... ..... ³o¥»¤â¥U¬O¬°¦³±M·~ªºµ{¦¡³]p®v©Ò¼¶¼gªº¡A¨Ï¥Î¥¦¥iÅý§Aºë³q¸ê®Æ®w¨t²ÎªººÞ²z©M¸ê®Æ®wÀ³¥Îµ{¦¡ªº¶}µo¡C¥»®Ñ°£¤F¤¶²Ð§¹¾ãªºSQL Server®Ö¤ßÆ[©À¡A¨Ã¦b®Ñ¤¤¤ÎCD-ROM´£¨Ñ¸Ô²Óªºµ{¦¡½d¨Ò¡C¥t¥~¡AÁÙ¯S§O´£¨Ñ¦³ÃöÃö³s¦¡¸ê®Æ®w¥H¤Î«Ø¥ßSQL±Ôzªº«ü¤Þ¡A¥H¤Î¦p¦ó¨Ï¥ÎVisual Basicµo®iSQL ServerÀ³¥Îµ{¦¡¡C¦b¥»®Ñ¤¤¡A§A¥i¥H¾Ç¨ì¡G Ãö©ó¨Ï¥Î M.....§ó¦h ..... ..... .....§ó¦h ¥»®Ñ¬O§A·Ç³Æ·L³nÀË©w¦Ò¸Õ70-029¡GDesigning and Implementing Databases With Microsoft SQL Server7.0³Ì¨Îªº°Ñ¦Ò®ÑÂÇ¡A³o¥»¸g¹L·L³n»{ÃÒªº±M·~¬ãŪ«ü«n²[»\¤F¡G ©Ò¦³ªºÀË©w¥Ø¼Ð ³\¦h´I¦³¬D¾Ô©Êªº½Æ²ß°ÝÃD ¦b²{¹êÀô¹Ò¤º³]p»P¹ê§@SQL Server¸ê®Æ®wªº¤@¨Ç¹ê¥Î¸ê°T.....§ó¦h ¤º®e§¹¾ã¡B¸Ñ»¡¸Ô²Ó¡G¥»®Ñ¤¤¹ï©ó¸ê¾ãÓ¸ê®Æ®w¨t²Î¡BÃö³s¦¡¼Ò«¬¡BSQLªº»yªk»PÀ³¥Î¥H¤ÎSQL¬ÛÃö³nÅéÀ³¥Î¡A§¡¦³²M·¡ªº©w¸q¡B¸Ô²Óªº¤¶²Ð¡AÅýŪªÌªº¾Ç²ß§ó¤ã¹ê¡C ²z½×¹ê§@¨Ã«¡B§ó¯àÆF¬¡¹B¥Î¡G¥»®Ñ¤¤°£¤F¹ï¦U¶µ¨t²Î¦³²M·¡ªº©w¸q»¡©ú¥~¡A§óÁ|¥Îû¤uÁ~¸êªí¡B¾Ç¥Í¦¨ÁZªí¡B³q°T¸ô¡Kµ¥¦U¶µ¹ê¨Ò©M²z½×¬Û¤¬¬MÃÒ¡AÅýŪªÌÃö©À§ó²M´·¡A§ó¯à¯u¥¿ÆF¬¡¹B¥ÎSQL¡C ¹Ï¸Ñ¦¡»¡©ú¡B¸õÅD©Ê«ä¦Ò¡G¨C.....§ó¦h
¤½¤åºÞ²z¨t²Î 16Microsoft ^¤å¬d¸ß DBCC ¸ê®Æ®w³W®æ¤@P©ÊÀˬd Transact-SQL¡BANSI SQL-92 Scripting SQL ¦w¥þ±±ºÞ SQL Server ¬d¸ß¤ÀªR¾¹ ¦p¦ó¥Î Mail¡BAlerts¡BJobs ¨ÓºûÅ@ SQL Database IJµo¦¡µ{§Ç¡B¹wÀx¦¡µ{§Ç¡BOLE §Q¥Î SQL-DMO ¼¶¼gµ{¦¡ ºûÅ@¨t²Îªºªí®æ»Pµ{§Ç¡BÂê©w¡B¥æ.....§ó¦h ¥»®Ñ¯S¦â¥»®Ñ¬OMicrosoft BackOffice®loch 4.5¥|¤j¸ê·½¤u¨ã¤§¤@¡A±z±N¥i¦b¥»®Ñ¤¤¾Ç¨ì¥H¤Uªº¤º®e¡G SQL Server 7.0ªº¬[ºc»P¤¸¥ó ¦³Ãö®e¶q¡B¸ê·½¤Î¶Ç²ÎÀ³¥Îµ{¦¡ªº³W¹º °w¹ï¸ê®ÆÜÀx¡B¦æ°ÊÀ³¥Î¤Î½u¤W¤ÀªR³B²z¨Ó³¡¸pSQL Server¸Ñ¨M¤è®× ¾E²¾»P¤É¯Åªº¦Ò¶q«ÂI µ{¦¡ªº«Ø¸m ¯Á¤Þªº½Õ¾ã ºÃÃø±Æ¸Ñ ¨aÃø´_ì.....§ó¦h ..... .....§ó¦h ..... ¥»®Ñ¥Hªì¦¸¨Ï¥ÎSQL Server 7.0ªºÅªªÌ¬°¶D¨D¡Aº¥ý¤¶²Ð¸ê®Æ®w°ò¥»·§©À»PÃöÁp¦¡¸ê®Æ®wªº³W¹º§Þ¥©¡A§Y¨Ï¹ï¸ê®Æ®w¤£¼ô±xªºÅªªÌ¤]¯à«Ü§Ö¶i¤Jª¬ªp¡C±µµÛ°w¹ï¸ê®Æ®wªº«Øºc¤ÎSQL»yªk¶i¦æ¸Ñ»¡¤Î¥Ü½d¡AÅýŪªÌ¥R¥÷´x´¤SQL Serverªº³]pºëÅè¡A»´ÃP«Ø¥ß¡BÀ³¥Î¸ê®Æ®w¨t²Î¡C ¥t¥~¡A¦b«Ø¥ß¸ê®Æ®w¡B¸ê®Æªí¡BÃöÁp¡BViewB¯Á¤Þµ¥ª«¥ó®É¡A°£¤F¥i¥ÎSQL»yªk.....§ó¦h ±q SQL Server 7.0 ªº°ò¥»¬[ºc¶}©l¡A¸Ô²Ó¤¶²Ð SQL Server 7.0 ªº¦w¸Ë³W¹º¡B¸ê®Æ®wªº«Ø¥ß»P³W¹º¡B¦w¥þ©ÊºÞ²z¡B³Æ¥÷»P½Æ»s¡B¦øªA¾¹³Ì¨Î¤Æµ¥¦U¶µºÞ²zªÌ©Ò»Ý±¹ïªº¤u§@©MijÃD¡C¦¹¥~¡A®Ñ¤¤¤]¤¶²Ð¤F¸ê®ÆÜÀxªº¬ÛÃö¤º®e¡A¥]¬A¸ê®ÆÜÀxªº·§©À¡B¦p¦ó§Q¥ÎSQL Server 7.0¨Ó¹ê§@¸ê®ÆÜÀx..µ¥¹ê¥Î¤º®e¡C ¥»®Ñ¾A¦X¤w·|¨Ï¥Î SQL S.....§ó¦h ¥úºÐ¤º®e¡GMicrosoft SQL Server 7.0 120¤Ñ¥¿¦¡µû¦ôª© Microsoft SQL Server 7.0 ¸ê®Æ®w¤¸¥óService Pack 1 Microsoft SQL Server 7.0 OLAP Services Service Pack 1 ®Ñ¤¤½d¨Òµ{¦¡»P½d¨Ò¸ê®Æ®w ¤º®e²¤¶¡G¥»®Ñ¥úºÐ¤º§tMicr.....§ó¦h
¤½¤åºÞ²z¨t²Î 17..... ..... ..... ¥H¹ê¥Î¹ê§@¬°¥D¡A¥ô¦óªº¾Þ§@¨BÆJ¬Ò§¹¾ã¤¶²Ð¡Aµ´¤£§t½k±a¹L¡C ¥»®Ñ¯S§O«µøSQL Server 7.0¸ê®Æ®w²z½×ªº²`«×±´¯Á¡A¥H¤Î¸Ô²Óªº¹ê°ÈÀ³¥Î¡C §¹¥þ¥H¾Ç²ßªÌªº¨¤«×¨Ó¼¶¼g¡A¥þ³¡¤º®e±Ä¥ÎStep by Step¡]¨BÆJ¦¡¡^ªº¤è¦¡Á¿¸Ñ¡A¬ð¯}¾Ç²ßªÌ¾Ç²ßSQL Server¸ê®Æ®w¨t²Îªºª¼ÂIAµ´¹ï¹Ï¤å¨ÃZ¡AµL¥ô¦ó¾Ç²ß»Ùê¡C ¸Ô²ÓåªRSQL Server 7.0ªº¦UºØ¸ê.....§ó¦h ..... ¨C³¹¥H¶}©l¤§«e¶}©l¡AÅý±z¥ý¹ï§¹¦¨¦¹³¹°µ¦n·Ç³Æ¡C ¥un¦³¥i¯à¡A¨CÓ½Òµ{¤¤³£·|¥]§t¥iµ¹±z¾÷·|¨Ï¥Î³Q®i²{¹Lªº§Þ¥©©Î±´°Q´¿¸g´yz¹LªºÀ³¥Îµ{¦¡ªºµ{§Ç¡C©Ò¦³µ{§Ç¬O¥H¦b¦¹¬q¸¨¥ª¤èªº¶µ¥Ø²Å¸¹¨Ó¼Ð©úªº¡C.....§ó¦h ¥HVisual Basic¬°«eºÝ·f°t«áºÝSQL Server¸ê®Æ®w¦øªA¾¹¡A¤@ª½¬O¥D±q¬[ºc¦s¨úÀ³¥Î¤W¬Û·í«nªº²Õ¦X¡C¥»®Ñ¯S¦â§YµÛ«¦b¨â®M³nÅ骺¾ã¦X§Þ¥©¡AÀ³¥Î½dÃ¥«h¥]§t¤@¯ë¸ê®ÆºûÅ@»PIntranet/Internet¸ê®Æªº¦s¨ú§@·~¡C½×zªº¥DÃD¤À§O¦C¥Ü¦p¤U¡G ¸ê®Æ®wªº«Ø¸m»PºûÅ@ ¤¶²Ð¥D±q¬[ºc¨t²Î³W¹º¥HSQL Server 6.5/7.0¸ê®Æ®wªº«Ø¸m»PºûÅ@.....§ó¦h .....§ó¦h
¤½¤åºÞ²z¨t²Î 18..... ¥»®Ñ°£¤F¸Ô²Ó¤¶²Ð¦p¦ó¨Ï¥Î»PºÞ²zSQL Server 7.0¨t²Î¤§¥~¡A§@ªÌÁÙºë¤ß³]p¤F¤@¥Ü½d¸ê®Æ®w¡C¸Ó¥Ü½d¸ê®Æ®w¤¤°£¤F¦³¥Ü½dªº¸ê®Æ¥~¡A¹ï©ó¦p¦ó¸g¹L¥¿³W¤Æªº¤âÄò¨Ó³]p¸ê®Æ®w¤]¦³¸ÔºÉªº»¡©ú¡C¦b¦U³¹¸`¤¤§@ªÌ³]p¤F³\¦hªº½d¨Ò»P½m²ß¨Ãªþ¦³¸Ñµª¡A¨ä¥Øªº¬O§Æ±æÅªªÌ¥i¥Hªá¶O³Ì¤Öªº®É¶¡¨Ó¼ô±x¸ê®Æ®wªº³]p»PSQL Server 7.0ªº¾Þ§@¡C .....§ó¦h ¡½ ³W«h (rule)¡B¨î (constraint)¡B¥H¤Î¹w³] (default)¡½ ¹wÀxµ{§Ç (stored procedure)¡½ ¬yµ{±±¨î±Ôz¡½ IJµo (triggerr)¡½ ³]p¬d¸ß (query) ¿ï¶µ¡½ ¸ê®Æ®w½Æ»s (replication)¡½ DTC (Distributed Transaction Coordinator)¡½ SQL S.....§ó¦h ..... ùþ SQL Server²¤¶ùþ SQL Server 7.0·s¥¯à²¤¶ù?Windows NT²¤¶ùþ ¸ê®Æ®w°ò¥»·§©Àùþ SQL Server©M¤u¨ãµ{¦¡ªº¦w¸Ë©M³]©wùþ ¦h¼h¦¡¡]Multi-Tier¡^¬[ºc¨t²Îùþ ¸ê®Æ®w¡Bªí®æ¤Î¥æ©ö°O¿ýùþ Transact-SQLùþ ªí®æ¸ê®Æªº·s¼W¡B²¾°£¤Î×§ïùþ À˵ø¡]View¡^ùþ ¯Á¤Þ¤ÎÁä¡]Key¡^ùþ ¥æ©ö¡]Transacti.....§ó¦h ¥»®Ñ¥H´`§Çº¥¶iªº¤è¦¡¤¶²ÐSQL Server 7¡A±q¦w¸ËSQL Server¡B¸ê®Æ®w¸Ë¸m¨ì¸ê®Æ®wª«¥óªº«Ø¥ßºÞ²z(¥]§t¤Fªí®æ¡BIJµo¾¹¡K)¡A¶i¦Ó¤¶²Ð§ó²`¤Jªº¦w¥þ»{µý¡B¸ê®Æ®w³Æ¥÷µ¥¡A±q¦w¸Ë¨ìÀ³¥Î³£¸Ô¹ê¤¶²Ð¡AÅý±z§Ö³t¾Ç²ß¡A»´ÃPºë³qSQL Server 7¡C.....§ó¦h ..... ¥»®Ñ¬OMicrosoft BackOffice(tm) Resource Kit¸ê·½¤u¨ã¤â¥Uªº¨t¦C±Ð§÷¤§¤@¡C¦b³o¥»®Ñ¸Ì±¡A§A¥i¥H§ä¨ì¥]ù¸U¶Hªº¸ê°T¡A¥]¬A¡G ÁA¸ÑMicrosoft SQL Serverªº¬[ºc ¤É¯Å¦ÜMicrosoft SQL Server 6.5©Î§ó·sª©¥»ª÷ ³Wµe»P§G¸pMicrosoft SQL Serverªº¹ê°È°ÝÃD»P¸Ñ¨M¤§¹D ¨ÏMic.....§ó¦h
¤½¤åºÞ²z¨t²Î 19³o¬O¤@¥»¥ÑMicrosoft»{¥iªº»{ÃÒ«ü¾É¤â¥U¡A¤º®e§t»\¤F³q¹LSQL SERVER 6.5 DESIGN & IMPLEMENTATION »{ÃÒ©ÒÀ³¸Óª¾¹Dªº¤@¤Á¡AÅý§A±q¥Í¤âÅܦ¨±M®a¡CMCSE»{ÃÒ«ü¾É¤â¥U-SQL SERVER 6.5 DESIGN & IMPLEMENTATION§¹¾ãªº¤º®e¥]§t¤F¦Ò¸Õ©Ò¦³¥DÃD¥]¬A¡G¸ê®Æ¼Ò¦¡ ( Data Modeling .....§ó¦h Microsoft©Ò»{¥iªººô¸ô±M·~±Ð§÷TestPrep¥]¬A70-26¸ÕÃDMicrosoft Certified Professional©Ò»{¥iªº±Ð§÷CD-ROM¥]¬A¿W¤@µL¤GªºTestPrep¼ÒÀÀ¸ÕÃD¡E¥]§t±z¥²»Ýºë³qªº§Þ³N¤Î³q¹L¦Ò¸Õªº©Ò¦³¸ê°T¡E³z¹L¨C³¹ªº´úÅç±z¯à¤F¸Ñ¨Ã´£¤É¦Û¤vªº¹ê¤O¡E¿W¤@µL¤GªºTestPrep¼ÒÀÀ¯u¥¿ªº¦Ò¸ÕMCSE°V½m¤â¥U--SQL SER.....§ó¦h ¡m·L³nSQL¦øªA¾¹±´¯¦¡n¬O¦P®É°w¹ï¸gÅçÂ×´Iªº¸ê®Æ®wºÞ²zû©Mªì¾ÇªÌ©Ò¼gªº¡C¥¦¤À¦¨¨âÓ³¡¤Àªº³¹¸`¯à°÷À°§UºÞ²z§ä¥X¤ÎÁA¸Ñ¥L̲¶·ª¾¹Dªº¡C¨C¤@³¹ªº²Ä¤@³¡¤À´£¨ÑÁA¸Ñ¸Ó¥DÃD©Òªº¸Ô²ÓI´º¸ê®Æ¡M¥H¤Î¤j¶qªº¹ê¥Î¸ê°T¡M±z¥i¥H±N³o¨Ç¸ê°T¹B¥Î¨ì¥Í²£Àô¹Òªº·L³nSQL¦øªA¾¹¹q¸£¤W¥H¸`¬Ù±zªº®É¶¡©M·Ð´o¡C¨C¤@³¹ªº¹ê¥Î«ü«n³¡¤À«h¤@¨B¤@¨B¦a»¡©ú¦p¦ó¹ê»Ú§¹¦¨¨º¤@³¹©Ò°Q½×ªº¥DÃD¡C ¥».....§ó¦h ..... ..... ³Ì§¹¾ãªºSQL Server¨Ï¥Î°Ñ¦Ò¤â¥U¡ESQL Server¸ê®Æ®w©MWebªº³s±µ¡E¦p¦ó±NAccess¸ê®Æ®w²¾´Ó¨ìSQL Server¤W¡Eºë³qSQL Serverªº³W«h¡BIJµo¤ÎÀx¦s¨ç¼Æ¡E¦p¦ó¶i¦æ¸ê®Æ®wªº½Æ»s¡E¦p¦ó§Q¥ÎSQL Server¶}µo¥D±q¦¡µ{¦¡¦p¦ó±NOffice 97 ¾ã¦X¨ìSQL Server¤¤SQL Serverªº¦w¥þ±¹¬I¥þ²y¾P°â¶q²Ä¤@¦W¡I¥[¤J.....§ó¦h ³Ì§¹¾ãªºSQL Server¨Ï¥Î°Ñ¦Ò¤â¥U¡E¦p¦ó¦w¸ËSQL Server¡E¸ê®Æ¼Ò«¬¤Î¥D±q¦¡¬[ºc¨t²Î¡E¦ó¿×¸Ë¸m¡B¸ê®Æ®w¡Bªí®æ¤Î¥æ©ö°O¿ý¡E¦ó¿×Transact-SQL¡E¦ó¿×À˵ø¡BÁä¡B¯Á¤Þ¤ÎÂê©w¦p¦ó¨Ï¥ÎSQL¤º«Ø¨ç¼Æ¥þ²y¾P°â¶q²Ä¤@¦W¡I¤ºªþ¥úºÐ¥þ¥@¬É³Ì¨üÅwªïªº¸ê®Æ®w³nÅ骺³Ì¨Î°Ñ¦Ò®ÑÅý§A§¹¥þµo´§SQL Serverªº©Ò¦³¥\¯à ¡V ¹ê²{¸ê°T««¤â¥i±oªº¹Ò¬É¥»®Ñ¬OQue/.....§ó¦h .....
¤½¤åºÞ²z¨t²Î 20..... ..... ..... ..... ..... .....
|
½u¤Wpºâ-²z°]³W¹º
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||