SQL Server 2012Ä_¨å(²Ä4ª©) ( ²Åé ¦r) |
§@ªÌ¡G[¬ü]Adam Jorgensen¡APatrick LeBlanc¡AJose Chinchilla¡AJorge Segarra¡AAaron Nelson µÛ | Ãþ§O¡G1. -> ¸ê®Æ®w -> SQL Server |
ĶªÌ¡G±i¼z®S Ķ |
¥Xª©ªÀ¡G²MµØ¤j¾Ç¥Xª©ªÀ | 3dWoo®Ñ¸¹¡G 38393 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT°â»ù¡G 640 ¤¸ |
¥Xª©¤é¡G4/30/2014 |
¶¼Æ¡G974 |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ²Åé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9787302360254 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡GÅwªï¾\Ū¥»®Ñ¡CSQL Server¬O¤@ÓÀu²§ªº¼Æ¾Ú®w²£«~¡A¥¦ªº©Ê¯à¦n¡B¥i¾a©Ê°ª¡B©ö¤_ºÞ²z¡A´£¨Ñ¤F·sªºÅé¨tµ²ºc¿ï¶µ¡A¤¹³\¶}µo¤Hû©ÎDBA±±¨î¤p²Ó¸`¡CSQL Server¬O¼Æ¾Ú®w¶}µo¤Hû¹Ú´K¥H¨Dªº¨t²Î¡C ¤@¨¥½ª¤§¡ASQL Server 2012¬O¥ø·~¯Åªº¨ô¶V²£«~¡CSQL Server 2012¬°³]p¥iÂX®i©Ê§ó°ª¡B§ó±j¤jªº¨t²Î´£¨Ñ¤F´XÓ·sªº¥i¯à©Ê¡C¥»®Ñªººn¥Ø¼Ð¬O»PŪªÌ¦@¨É¨Ï¥ÎSQL Serverªº¼Ö½ì¡C »PÄ_¨å¨t¦Cªº©Ò¦³¹Ï®Ñ¤@¼Ë¡A¥»®Ñ¤]¥]§t¿Ë¦Û°Ê¤âªº±Ðµ{©M²{¹ê¥@¬Éªº¹ê»ÚÀ³¥Îµ{§Ç¡AÁÙ¥]§t°Ñ¦Ò¸ê®Æ©MI´º«H®§¡A¬°ÅªªÌ©Ò¾Çªº¤º®e´£¨Ñ¤W¤U¤å¡C¦ý¬O¡A¬°¤FÅn¬A³oÓ´_Âø²£«~ªº¨CÓ©R¥Oªº¨CÓ²Ó¸`¡A»Ýn¼Æ¤d¶ªº½g´T¡A©Ò¥H¥»®Ñªº²Ä¤GӥؼЬO´£¨Ñ²©úªººî¦X©ÊSQL Server 2012«ü«n¡CŪ§¹¥»®Ñ¡AŪªÌ´N¥i¥H¶}µo©MºÞ²zSQL Server 2012¼Æ¾Ú®w©MBIÀô¹Ò¤F¡C ¤@¨Ç¤H¬O¦ÑŪªÌ¤F¡A³q¹L¥H«eªºª©¥»¼ô±x¤F¨ä½s±Æ¤è¦¡¡C§Y«K¦p¦¹¡AŪªÌ¤]·|µo²{³oÓª©¥»ªº´XÓ·s¯SÂI¡G ¡´ ¤j¦h¼Æ³¹¸`ªº¡§·s¼W¥\¯à¡¨´£¨Ñ¤F¥\¯àªº¶}µo®É¶¡ªí¡A¥H«KŪªÌ¹wp¨ä¶i«×¡C ¡´ ÂX®i¤F¦³ÃöBIªº³¹¸`¡C ¡´ T-SQLªº·§©ÀÃöª`³Ì¦³¥Î¡B³Ì¨Îªº»â°ì¡A¦P®É´£¨Ñ¤F§ó¦hªº¥Ü¨Ò¡C ¡´ ¥]§t¤@¨Ç·s¥\¯à¡A¦pAlways On¡B©Ê¯à½Õ¾ã¤u¨ã©M¦C¦sÀx¯Á¤Þµ¥¶µ¡C ¡´ ¥]§t©Ò¦³³Ì·sªº¥\¯à¡A¥]¬AT-SQL¡B¤ÞÀº¡BBIµ¥¡A©Ý¼e¤F¥»®Ñªº¤º²[¡C 0.1 ¥»®ÑŪªÌ¹ï¶H SQL Server»â°ì¤¤¦³5Ó¤£¦Pªº¨¤¦â¡G ¡´ ¼Æ¾Ú¬[ºc®v/¼Æ¾Ú«Ø¼Ò®v ¡´ ¼Æ¾Ú®w¶}µo¤Hû ¡´ ¼Æ¾Ú®wºÞ²zû ¡´ BI (Business Intelligence)¶}µo¤Hû ¡´ PTO©Ê¯à½Õ¾ã©MÀu¤Æ±M®a ¥»®Ñ¸g¹L¥J²Ó³W¹º¡A¬ã¨s¤F³o5Ó¨¤¦â¡C µL½×¬O¼Æ¾Ú®w¶}µo¤HûÁÙ¬O¼Æ¾Ú®wºÞ²zû¡AµL½×¬Oªì¾ÇªÌ¡B¦³1¦~¸gÅçÁÙ¬O5¦~¸gÅ窺¤Hû¡A¥»®Ñ³£¥]§t¹ï§A¦³¥Îªº«H®§¡C ¥»®Ñ¥Dn°w¹ï¤¤¯Å¼Æ¾Ú®w±M·~¤Hû¡A¦ý¨C³¹³£±q¤@Ó°²³](§YŪªÌ¥H«e±q¨S¦³¯AÂy¹L¬ÛÀ³¥DÃD)¶}©l¡A±µµÛ³v¨B°Q½×¸Ó¥DÃD¡A¦}§e²{¦³°Ï§Oªº«H®§¡C ¦b³o¨Ç¥\¯àªº°ªºÝ¡A¥»®Ñ§â¤¤¯Å±M·~¤Hû±a¤J¬Y¨Ç³Ì¦³·N¸qªº°ª¯Å»â°ì¡C¨Ò¦p¡A¦bT-SQL¬d¸ß¡B¯Á¤Þµ¦²¤©M¼Æ¾ÚÅé¨tµ²ºc¤è±¦³«D±`°ª¯Åªº¤º®e¡C 0.2 ¥»®Ñªº²Õ´µ²ºc SQL Server¬O¤@ÓÃe¤jªº²£«~¡A¦³¼Æ¤Q¶µ§Þ³N©M¬Û¤¬ÃöÁpªº¥\¯à¡C¶È²Õ´³o¤\«pªº®Ñ´N¬O¤@Ó¥O¤H±æ¦Ó¥Í¬Èªº¥ô°È¡C ³o¤\«pªº®ÑÁÙ¥²¶·«K¤_¾\Ū©MÀ˯Á¡C¥»®Ñªº9Ó³¡¤À«ö·Ó§@·~¨¤¦â¡B¶µ¥Ø¬yµ{©M§Þ³N¶i«×¨Ó²Õ´¡G ²Ä¢¹³¡¤À¡G¤Jªù ²Ä¢º³¡¤À¡G«Ø¥ß¼Æ¾Ú®w©M³B²z¼Æ¾Ú ²Ä¢»³¡¤À¡G°ª¯ÅT-SQL¼Æ¾ÚÃþ«¬©M¬d¸ß§Þ³N ²Ä¢¼³¡¤À¡G¨Ï¥ÎT-SQL½sµ{ ²Ä¢½³¡¤À¡G¥ø·~¼Æ¾ÚºÞ²z ²Ä¢¾³¡¤À¡G«OÅ@SQL Server ²Ä¢¿³¡¤À¡GºÊµø©M¼fp ²Ä¢À³¡¤À¡G©Ê¯à½Õ¾ã©MÀu¤Æ ²Ä¢Á³¡¤À¡G°Ó·~´¼¯à 0.3 SQL ServerÁp¾÷ÂO®Ñ ¥»®Ñ¤£¬OÁp¾÷ÂO®Ñªº§ï½sª©¥»¡A¤]¤£¥´ºâ´À¥NÁp¾÷ÂO®Ñ¡C¥»®Ñ¦}¤£·|¦C¥X¨CÓ©R¥Oªº§¹¾ã»yªk¡X¡X«²{Áp¾÷ÂO®Ñ¨S¦³¥ô¦ó»ùÈ¡C¦Ó¬O®i¥ÜŪªÌ»Ýnª¾¹Dªº¤º®e¡A¥H«K³Ì¤j«×¦a´x´¤SQL Server¡A¾Ç²ß§@ªÌ¤¶²Ðªº¸gÅç¡C ¥»®Ñ®U®U¹D¨Ó¡A¹³ªB¤Í¨º¼Ëµ¹ÅªªÌ¸ÑÄÀ¨CÓ¯S©Ê¡X¡XŪªÌ·|±o¨ì¤@Ó·s¥ô°È¡A¬°§¹¦¨¸Ó¥ô°È¡AŪªÌ»Ýn¨Ï¥Î¤@Ó¤£¼ô±xªº¯S©Ê¡A¦Ó¥»®Ñ·|«ü¤ÞŪªÌ¤Á¤¤n®`¡A§Ö±¶¦a§¹¦¨¥ô°È¡C ¥»®Ñ¥]§t¤F«nªº·§©À¡B¯u¹ê¨Ò¤l©M³Ì¨Î¹ê½î¡C 0.4 ¬ù©w©M¯S¦â ¥»®Ñ¥]§t´XÓ¤£¦Pªº²Õ´¯SÂI©M±Æª©¯SÂI¡A¥HÀ°§UŪªÌ±q«H®§¤¤´x´¤³Ì¦hªº¤º®e¡C ´£¥Ü¡Bª`·N¡Bĵ§i©M¥æ¤e°Ñ¦Ò ¥un§@ªÌ·QÅýŪªÌª`·N¬Y¨Ç«nªº«H®§¡A³o¨Ç«H®§´N·|Åã¥Ü¬°´£¥Ü¡Bª`·N©Îĵ§i¡C ĵ§i¡G ³o¨Ç«H®§«Ü«n¡A¥Î¤@Ó¯S®íªº¹Ï¼ÐÅã¥Ü¦b¤@Ó³æ¿Wªº¬q¸¨¤¤¡Cĵ§i´£¨Ñn¯S§O¤p¤ßªº¨Æ±¡¡A³o¨Ç¨Æ±¡¥i¯à¥u·|±a¨Ó¤£«K¡A©ÎªÌ·|¼ç¦b¦a·l®`¼Æ¾Ú©Î¨t²Î¡C ´£¥Ü¡G ¤@¯ë¥Î¤_´£¨Ñ¥i²¤Æ¤u§@ªº«H®§¡X¡X§ó®e©ö§¹¦¨¥ô°Èªº¯S®í§Ö±¶¤è¦¡©Î¤èªk¡C¦b´£¥Ü¤¤±`·|¦C¥X¬ÛÃöªº.sys¤å¥ó¡C ª`·N¡G ´£¨Ñ¤F¨ä¥L»²§U«H®§¡A³o¨Ç«H®§¬O¦³¯qªº¡A¦ý¦³®É¶W¥X¤F·í«e«H®§ªºSÃ¥¡C ¥æ¤e°Ñ¦Ò¡G¬O¬ÛÃö¤º®eªº¸ô¼Ð¡A¬ÛÃö¤º®e¥i¯à¦bºôµ¸¡B¥»®Ñªº¥t¤@³¹©Î¥t¤@¥»®Ñ¤W¡C ·s¼W¤º®e©M³Ì¨Î¹ê½îÃäÄæ ¥»®Ñ¦³¨âÓ¯S®íªºÃäÄæ¡G¡§·s¼W¥\¯à¡¨©M¡§³Ì¨Î¹ê½î¡¨ÃäÄæ¡C SQL Serverªº·s¼W¥\¯à ¥un¥i¯à¥B¤Á¦X¹ê»Ú¡A´N¥]§t¤@ÓÃäÄæ¡A±j½Õ¥»³¹¤¶²Ðªº·s¥\¯à¡C³o¨ÇÃäÄæ±`±`ĵ§iŪªÌ¡Aþ¨Ç¥\¯à³Q§R°£¤F¡Aþ¨Ç¥\¯à¤w¤£«Øij¨Ï¥Î¤F¡C³q±`³o¨ÇÃäÄæ©ñ¦b¸Ó³¹ªº¶}ÀY¡C
³Ì¨Î¹ê½î ¥»®Ñ°ò¤_SQL Server¶}µo¤Hû©MºÞ²zûªº¹ê½î¸gÅç¡C¬°¤F¯à¨ÏŪªÌ±q³o¨Ç¸gÅ礤Àò¯q¡A³Ì¨Î¹ê½î¥HÃäÄæ§Î¦¡Å㦡¦ó®É¦ó¦aÀ³¥Î³o¨Ç¸gÅç¡C 0.6 §ó¦h¸ê·½ ³o¬OSQL Serverªº¥@¬É¡A¥J²Ó¬ã¨s¦}¨Ï¥ÎSQL Server¡C¹Á¸Õ·s²z©À¡A¦pªGµo²{°ÝÃD©Î¦nªF¦è¡A½Ð³X°ÝWrox½×¾Â(¥Ñ§@ªÌ¹Î¶¤ºÊ±±)¡A¸Ó½×¾Âªº¦a§}¬Owww. wrox.com¡C °Ñ¥[¦³§@ªÌµo¨¥ªº·|ij©Î¥Î¤á²Õ¡C§@ªÌº@·N·|¨£§A¡Aµ¹§Añ¦W¡CŪªÌ¥i¥H¦bSQLSaturday.com©MSQLPASS.org¤F¸Ñ§@ªÌ¦b¦ó®É¦ó¦aµo¨¥¡C ¹³SQL Server³o¤\¤jªº¥DÃD¡B³o¤\±j¤jªºªÀ°Ï¡A¦³³\¦h¥i¥Îªº¸ê·½¡C¦ýSQL Server¤]¦³³\¦hÃøÂI¡A¹ï¤_±ÀÂ˪º¨ä¥L¸ê·½©MSQL Server¹Ï®Ñ¡A¥i³X°Ý¥»®Ñªººô¯¸¡C
|
¤º®e²¤¶¡G¦pªG±z¬O¤@¦ì¼Æ¾Ú®wºÞ²zû©Î¶}µoªÌ¡A¨º¤\ SQL Server 2012Ä_¨å(²Ä4ª©) ±N¬O±z¥þ±¤F¸ÑSQL Server 2012ªº ¤@¯¸¦¡¸ê·½¡C¥»®Ñ²`¤J±´°Q®Ö¤ß§Þ³N¡B³Ì¨Î¹ê½î©Mºë§®¤è ®×¡A¦CÁ|Â×´Iªº¹ê¨Ò©M¥Ü¨Ò¥N½X¡A¦}§¹¾ã¤¶²ÐAlwaysOn³s ±µ¡B·s¯Á¤Þ¡BPower View¡B¥D¼Æ¾ÚªA°È¡B¼Æ¾Ú½è¶qªA°È©M PowerPivot for SQL Server 2012µ¥·s¥\¯à¡C ¡´ ²`¤J±´°QSQL Server 2012ªº©Ò¦³·s¥\¯à ¡´ ²z¸Ñ°ª¯ÅT-SQL¼Æ¾ÚÃþ«¬©M¬d¸ß§Þ³N ¡´ ½T«O¥ô°ÈÃöÁ䫬À³¥Îµ{§Çªº°ª¥i¥Î©Ê ¡´ ¶}©l¨Ï¥ÎSQL Azure¶i¦æ¤ªpºâ ¡´ ¼ô±x·sªº¦w¥þ©MÝ®e³]¸m ¡´ ³q¹LBI¡B¼Æ¾ÚÜÀx©MEnterprise Information Management ¸Ñ¨M¤è®×¤u¨ã¨Ï¥Î¼Æ¾Ú ¡´ §Ö³t¤F¸ÑBI¤u¨ã¶°ªº³Ì·s§ï¶i |
¥Ø¿ý¡G²Ä¢¹³¡¤À ¤J ªù ²Ä1³¹ SQL Server¥@¬É 3 1.1 SQL Serverµo®i²¥v 3 1.2 ¼Æ¾Ú®w¥«³õ¤¤ªºSQL Server 4 1.2.1 SQL ServerªºÄvª§¹ï¤â 4 1.2.2 SQLªÀ°Ïªº±j¤j¤§³B 4 1.3 SQL Serverªº²Õ¥ó 5 1.3.1 ¼Æ¾Ú®w¤ÞÀº 5 1.3.2 ªA°È 5 1.3.3 °Ó·~´¼¯à 6 1.3.4 ¤u¨ã©Mªþ¥[²Õ¥ó 7 1.3.5 Áp¾÷¸ê·½ 9 1.4 SQL Server 2012ªºª©¥» 9 1.5 SQL Server 2012ªºÅãµÛ¼W±j 10 1.6 ¤pµ² 11 ²Ä2³¹ ¼Æ¾Ú¬[ºc 12 2.1 «H®§¬[ºcì«h 12 2.2 ¼Æ¾Ú®w¥Ø¼Ð 13 2.2.1 ¾A¥Î©Ê 13 2.2.2 ¥iÂX®i©Ê 14 2.2.3 ¼Æ¾Ú§¹¾ã©Ê 14 2.2.4 ©Ê¯à/¥iÂX®i©Ê 15 2.2.5 ¥i¥Î©Ê 15 2.2.6 ¦w¥þ©Ê 15 2.3 ´¼¯à¼Æ¾Ú®w³]p 17 2.3.1 ¼Æ¾Ú®w¨t²Î 17 2.3.2 ª«²z¬[ºc 18 2.3.3 °ò¤_¶°ªº¬d¸ß 19 2.3.4 ¯Á¤Þ 19 2.3.5 ¦}µo©Ê 19 2.3.6 °ª¯Å¥iÂX®i©Ê 20 2.3.7 ©Ê¯à®Ø¬[ 20 2.3.8 ª§Ä³©M²§Ä³ 21 2.4 ¤pµ² 21 ²Ä3³¹ ¦w¸ËSQL Server 23 3.1 ·Ç³ÆªA°È¾¹ 24 3.1.1 µw¥ó©M³n¥ó»Ý¨D 24 3.1.2 ¾A·í×¸É 25 3.1.3 ¨¾¤õùÙ 25 3.2 ¿ï¾Üª©¥» 26 3.2.1 ¤£¦Pª©¥»¤§¶¡ªº°Ï§O 27 3.2.2 ¥H¦Zªº°¯Å 27 3.2.3 ¥H¦Zªº¤É¯Å 29 3.2.4 ³\¥i¤è±ªº°Ï§O 30 3.3 ¦w¸Ë¹Lµ{ 31 3.3.1 SQL Server 2012¦w¸Ë¤¤¤ß 32 3.3.2 ³q¹L¦w¸Ë¤¤¤ß¦w¸Ë SQL Server 2012 33 3.3.3 ³q¹L©R¥O¦æ¦w¸Ë SQL Server 2012 41 3.3.4 ³q¹LPowerShell¦w¸Ë SQL Server 2012 43 3.3.5 §¹¦¨¦w¸Ë¦Zªº¥ô°È 46 3.4 ¤pµ² 49 ²Ä4³¹ «È¤áºÝ³s±µ 50 4.1 ±Ò¥ÎªA°È¾¹³s±µ 50 4.1.1 ªA°È¾¹°t¸mºÞ²z¾¹ 51 4.1.2 SQL¥»¦a«È¤áºÝ³s±µ(SNAC) 52 4.2 SQL Server¥»¦a«È¤áºÝ¯S©Ê 52 4.2.1 ¹ïLocalDBªº¥»¦a «È¤áºÝ¤ä«ù 53 4.2.2 ¤¸¼Æ¾Úµo²{ 53 4.2.3 °ª¥i¥Î©Ê/¨aÃø«ì´_¤ä«ù 53 4.2.4 §ï¶iªº¤é´Á/®É¶¡¤ä«ù 53
4.2.5 ³X°ÝÂX®i¨Æ¥ó¤é§Ó¤¤ªº ¶EÂ_«H®§ 54 4.2.6 ODBC¯S©Ê 54 4.2.7 ¦h¬¡°Êµ²ªG¶°(MARS) 54 4.2.8 XML¼Æ¾ÚÃþ«¬ 55 4.2.9 ¥Î¤á©w¸qÃþ«¬ 55 4.2.10 ¤jÈÃþ«¬ 55 4.2.11 ¤å¥ó¬y¤ä«ù 55 4.2.12 ¹L´Á±K½X³B²z 55 4.2.13 §Ö·Ó¹jÂ÷ 56 4.3 ¤pµ² 56 ²Ä5³¹ SQL ServerºÞ²z©M¶}µo¤u¨ã 57 5.1 ²Õ´¬É± 58 5.1.1 µ¡¤f©ñ¸m 59 5.1.2 ¤W¤U¤åµæ³æ 61 5.2 Registered Servers 61 5.2.1 ºÞ²zªA°È¾¹ 61 5.2.2 ªA°È¾¹²Õ 62 5.3 Object Explorer 63 5.3.1 ¾É¯è¾ð 63 5.3.2 ¿z¿ïObject Explorer 65 5.3.3 Object Explorer Details¶± 65 5.3.4 ªí³]p¾¹ 65 5.3.5 ³Ð«Ø¼Æ¾Ú®wÃö¨t¹Ï 66 5.3.6 Query Designer 67 5.3.7 Object Explorer³øªí 68 5.4 ¨Ï¥ÎQuery Editor 69 5.4.1 ¥´¶}³s±µ¨ìªA°È¾¹ªº¬d¸ß 69 5.4.2 ¥´¶}.sql¤å¥ó 70 5.4.3 §Ö±¶¤è¦¡©M®Ññ 71 5.4.4 ¬d¸ß¿ï¶µ 72 5.4.5 °õ¦æSQL§å³B²z 72 5.4.6 µ²ªG 73 5.4.7 ¬d¬Ý¬d¸ß°õ¦æp¹º 73 5.5 ¨Ï¥ÎSolution Explorer 74 5.6 ¥H¼ÒªO©M¥N½X¤ù¬q¬° °ò¦½s¼g¥N½X 74 5.6.1 ¼ÒªOªº¨Ï¥Î 74 5.6.2 ¥N½X¤ù¬qªº¨Ï¥Î 75 5.7 ¤pµ² 75 ²Ä¢º³¡¤À «Ø¥ß¼Æ¾Ú®w©M³B²z¼Æ¾Ú ²Ä6³¹ °ò¥»ªº¬d¸ß¬y 79 6.1 ¤F¸Ñ¬d¸ß¬y 80 6.1.1 ¬d¸ß»y¥yªº»yªk¬y 80 6.1.2 ¬d¸ß»y¥yªº¹Ï§Î¤Æµø¹Ï 80 6.1.3 ¬d¸ß»y¥yªºÅÞ¿è¬y 82 6.1.4 ¬d¸ß»y¥yªºª«²z¬y 82 6.2 From ¤l¥y¼Æ¾Ú·½ 83 6.2.1 ¥i¯àªº¼Æ¾Ú·½ 83 6.2.2 ªí§O¦W 84 6.2.3 ªí¦WºÙ 85 6.2.4 §¹¥þ©wªº¦WºÙ 85 6.3 WHERE±ø¥ó 86 6.3.1 ¨Ï¥ÎBETWEEN·j¯Á±ø¥ó 86 6.3.2 »P¦Cªí¤ñ¸û 87 6.3.3 ¨Ï¥ÎLIKE·j¯Á±ø¥ó 89 6.3.4 ¦hÓWHERE±ø¥ó 91 6.4 ¦C¡B¬P¸¹¡B§O¦W©Mªí¹F¦¡ 92 6.4.1 ¬P¸¹ 92 6.4.2 §O¦W 93 6.4.3 ©wªº¦C 94 6.5 µ²ªG¶°±Æ§Ç 94 6.5.1 ³q¹L¨Ï¥Î¦C¦WºÙ¨Ó«ü©w¶¶§Ç 95 6.5.2 ¨Ï¥Îªí¹F¦¡«ü©w¶¶§Ç 96 6.5.3 ¨Ï¥Î¦C§O¦W«ü©w¶¶§Ç 97 6.5.4 ¨Ï¥Î¦Cªº¶¶§Ç¦ì¸m 97 6.5.5 ORDER BY©M±Æ§Ç³W«h 97 6.6 SELECT DISTINCT 99 6.7 TOP()¿×µü 100 6.7.1 WITH TIES¿ï¶µ 102 6.7.2 ÀH¾÷¦æ¿ï¾Ü 102 6.8 ¤pµ² 103 ²Ä7³¹ Ãö¨t¼Æ¾Ú®w³]p©M³Ð«Ø ª«²z¼Æ¾Ú®w¬[ºc 104 7.1 ¼Æ¾Ú®w°ò¦ª¾ÃÑ 104 7.1.1 ¼Æ¦r¤Æ¼Æ¾Ú®wªºÀuÂI 105 7.1.2 ªí¡B¦æ©M¦C 105 7.1.3 ¼Æ¾Ú®w³]p¶¥¬q 106 7.1.4 ³WS¤Æ 106 7.1.5 ¤TÓ¡§¤@³W«h¡¨ 107 7.1.6 ¼ÐÃѹêÅé 107 7.1.7 ªx¤Æ 108 7.1.8 ¥DÁä 109 7.1.9 ¥~Áä 109 7.1.10 °ò¼Æ 110 7.1.11 ¥i¿ï©Ê 110 7.2 ¼Æ¾Ú³]p¼Ò¦¡ 111 7.2.1 ¤@¹ï¦h¼Ò¦¡ 112 7.2.2 ¤@¹ï¤@¼Ò¦¡ 112 7.2.3 ¦h¹ï¦h¼Ò¦¡ 112 7.2.4 ¶W«¬/¤l«¬¼Ò¦¡ 114 7.2.5 °ì§¹¾ã©Ê¬d§ä¼Ò¦¡ 115 7.2.6 »¼Âk¼Ò¦¡ 116 7.2.7 ¼Æ¾Ú®w³]p¼h 118 7.3 S¦¡ 118 7.3.1 ²Ä¤@S¦¡(1NF) 118 7.3.2 ²Ä¤GS¦¡(2NF) 119 7.3.3 ²Ä¤TS¦¡(3NF) 120 7.3.4 Boyce-Codd S¦¡(BCNF) 121 7.3.5 ²Ä¥|S¦¡(4NF) 122 7.3.6 ²Ä¤S¦¡(5NF) 122 7.4 ¾Ô²¤¦Ò¼{¨Æ¶µ 122 7.4.1 ¦ó®É¦b¤£¦Pªº¼Æ¾Ú®w¤¤ ³æ¿W¦sÀxªí 122 7.4.2 ¦ó®É¨Ï¥Î¦óºØ¬[ºc 123 7.5 ¤pµ² 123 ²Ä8³¹ ¼Æ¾ÚÃþ«¬¡Bªí¹F¦¡©M ¼Ð¶q¨ç¼Æ 124 8.1 ¼Æ¾ÚÃþ«¬ 124 8.1.1 ¦r²Å¼Æ¾ÚÃþ«¬ 124 8.1.2 ¼ÆȼƾÚÃþ«¬ 125 8.1.3 ¤é´Á/®É¶¡¼Æ¾ÚÃþ«¬ 125 8.1.4 ¨ä¥L¼Æ¾ÚÃþ«¬ 126 8.2 ºc«Øªí¹F¦¡ 126 8.2.1 ¹Bºâ²Å 127 8.2.2 «ö¦ì¹Bºâ²Å 128 8.2.3 CASEªí¹F¦¡ 130 8.2.4 SQL Server 2012·s¼Wªº ÅÞ¿è¨ç¼Æ 132 8.2.5 ¨Ï¥ÎªÅÈ 133 8.3 ¼Ð¶q¨ç¼Æ 138 8.3.1 ¥Î¤á©w¸q¨ç¼Æ 138 8.3.2 ¤é´Á©M®É¶¡¨ç¼Æ 139 8.3.3 SQL Server 2012·s¼Wªº¨ç¼Æ 142 8.4 ¦r²Å¦ê¨ç¼Æ 143 8.4.1 SUBSTRING(string¡A starting position¡Alength) 144 8.4.2 STUFF(string¡Ainsertion position¡Adelete count¡A string inserted) 144 8.4.3 CHARINDEX(search string¡A string¡Astarting position) 144 8.4.4 PATINDEX(pattern¡Astring) 144 8.4.5 RIGHT(string¡Acount)©M LEFT(string¡Acount) 145 8.4.6 LEN(string) 145 8.4.7 RTRIM(string)©M LTRIM(string) 145 8.4.8 UPPER(string)©M LOWER(string) 145 8.4.9 REPLACE(string¡Astring) 145 8.4.10 dbo.pTitleCase(source¡A search¡Areplace) 147 8.4.11 SQL Server 2012·s¼Wªº ¦r²Å¦ê¨ç¼Æ 148 8.5 Soundex¨ç¼Æ 148 8.5.1 ¨Ï¥Î SOUNDEX()¨ç¼Æ 149 8.5.2 ¨Ï¥ÎDIFFERENCE() Soundex ¨ç¼Æ 151 8.6 ¼Æ¾ÚÃþ«¬ªºÂà´«¨ç¼Æ 151 8.7 ªA°È¾¹Àô¹Ò«H®§ 154 8.8 ¤pµ² 155 ²Ä9³¹ ¥ÎÁp±µ¡B¤l¬d¸ß©MCTE ¦X¦}¼Æ¾Ú 156 9.1 ¨Ï¥ÎÁp±µ 157 9.1.1 ¤ºÁp±µ 158 9.1.2 ¥~Áp±µ 162 9.1.3 ¦ÛÁp±µ 167 9.1.4 ¥æ¤eÁp±µ 168 9.1.5 ¯S®íÁp±µ 169 9.2 ®t¶°¬d¸ß 170 9.2.1 ¥ª®t¶°¬d¸ß 170 9.2.2 ¥þ®t¶°¬d¸ß 171 9.3 ¨Ï¥ÎÁp¦X 171 9.3.1 UNION ALL¬d¸ß 171 9.3.2 ¥æ¶°Áp¦X 172 9.3.3 ®tÈÁp¦X/EXCEPT 173 9.4 ¤l¬d¸ß 173 9.4.1 ²³æ¤l¬d¸ß 174 9.4.2 §â¤l¬d¸ß¥Î§@¦Cªí 177 9.4.3 ´O®M¤l¬d¸ß 177 9.4.4 §â¤l¬d¸ß¥Î§@ªí 177 9.4.5 ¬ÛÃö¤l¬d¸ß 179 9.5 ¤pµ² 182 ²Ä10³¹ »E¦X¡Bµ¡¤f¤Æ©M±Æ¦W¼Æ¾Ú 183 10.1 »E¦X¼Æ¾Ú 183 10.1.1 °ò¥»»E¦X 183 10.1.2 »E¦X¡B¥§¡©MªÅÈ 185 10.2 µ²ªG¶°¤¤ªº¤À²Õ 185 10.2.1 ²³æ¤À²Õ 186 10.2.2 ¤À²Õ¶° 187 10.2.3 ¿z¿ï¤w¤À²Õªºµ²ªG 188 10.3 µ¡¤f¤Æ©M±Æ¦W 189 10.3.1 µ¡¤f¤Æ 189 10.3.2 OVER()¤l¥y 189 10.3.3 ¦bµ¡¤f¤º¤À°Ï 190 10.4 ±Æ¦W¨ç¼Æ 191 10.4.1 ROW_NUMBER()¨ç¼Æ 191 10.4.2 RANK()¨ç¼Æ©M DENSE_RANK()¨ç¼Æ 193 10.4.3 NTILE()¨ç¼Æ 195 10.4.4 »E¦X¨ç¼Æ 196 10.4.5 SQL Server 2012·s¼Wªº T-SQL¯S©Ê 197 10.4.6 «e¤@¦æ©M·í«e¦æ 198 10.5 ¤pµ² 199 ²Ä11³¹ ³q¹Lµø¹Ï§ë¼v¼Æ¾Ú 200 11.1 ¨Ï¥Îµø¹Ïªº²z¥Ñ 200 11.2 °ò¥»µø¹Ï 202 11.2.1 ¹B¥ÎQuery Designer ³Ð«Øµø¹Ï 202 11.2.2 ¥ÎDDL¥N½X³Ð«Øµø¹Ï 203 11.2.3 °õ¦æµø¹Ï 204 11.2.4 §ó§ï¦}§R°£µø¹Ï 205 11.3 ±q§ó¼sªxªº¨¤«×¬Ýµø¹Ï 206 11.3.1 ¦C§O¦W 206 11.3.2 ORDER BY©Mµø¹Ï 206 11.3.3 µø¹Ï¨î 207 11.3.4 ´O®Mµø¹Ï 207 11.3.5 ³q¹Lµø¹Ï§ó·s 209 11.3.6 µø¹Ï©M©Ê¯à 209 11.4 Âê©wµø¹Ï 210 11.4.1 ¥¼¸gÀˬdªº¼Æ¾Ú 210 11.4.2 «OÅ@¼Æ¾Ú 211 11.4.3 «OÅ@µø¹Ï 212 11.4.4 ¥[±Kµø¹ÏªºSELECT»y¥y 213 11.4.5 À³¥Îµ{§Ç¤¸¼Æ¾Ú 213 11.5 ¹B¥Î¦P¸qµü 214 11.6 ¤pµ² 214 ²Ä12³¹ ¦bSQL Server¤¤×§ï¼Æ¾Ú 215 12.1 ´¡¤J¼Æ¾Ú 216 12.1.1 ´¡¤J²³æªºÈ¦æ 216 12.1.2 ±qSELECT´¡¤Jµ²ªG¶° 219 12.1.3 ±q¦sÀx¹Lµ{´¡¤Jµ²ªG¶° 220 12.1.4 ³Ð«ØÀq»{¦æ 222 12.1.5 ¦b´¡¤J¼Æ¾Ú®É³Ð«Øªí 222
12.2 §ó·s¼Æ¾Ú 224 12.2.1 §ó·s³æÓªí 224 12.2.2 °õ¦æ¥þ§½·j¯Á©M´À¥N 225 12.2.3 §ó·s¼Æ¾Ú®É¤Þ¥Î¦hÓªí 226 12.3 §R°£¼Æ¾Ú 230 12.3.1 §R°£®É¤Þ¥Î¦hӼƾڷ½ 231 12.3.2 ¯ÅÁp§R°£ 232 12.3.3 ª«²z§R°£¼Æ¾Úªº¨ä¥L¿ï¾Ü 232 12.4 ¦X¦}¼Æ¾Ú 233 12.5 ªð¦^קï¦Zªº¼Æ¾Ú 237 12.5.1 ±q´¡¤Jªð¦^¼Æ¾Ú 237 12.5.2 ±q§ó·sªð¦^¼Æ¾Ú 237 12.5.3 ±q§R°£ªð¦^¼Æ¾Ú 238 12.5.4 ±q¦X¦}ªð¦^¼Æ¾Ú 238 12.5.5 §â¼Æ¾Úªð¦^¨ìªí¤¤ 239 12.6 ¤pµ² 239 ²Ä¢»³¡¤À °ª¯ÅT-SQL¼Æ¾ÚÃþ«¬©M¬d¸ß§Þ³N ²Ä13³¹ ¾Þ§@¼h¦¸µ²ºc 243 13.1 HierarchyID 243 13.1.1 ¿ï¾Ü³æÓ¸`ÂI 245 13.1.2 ·j¯Á¯ª¥ý¸`ÂI 246 13.1.3 °õ¦æ¤l¾ð·j¯Á 246 13.1.4 ´¡¤J·s¸`ÂI 247 13.2 HierarchyID¤èªk 248 13.3 ¯Á¤Þµ¦²¤ 250 13.4 ¼h¦¸µ²ºc¼Æ¾Úªº³Æ¿ï ¾Þ§@¤è¦¡ 251 13.4.1 »¼ÂkCTE 251 13.4.2 XML 252 13.5 ¤pµ² 253 ²Ä14³¹ ¨Ï¥ÎXML¼Æ¾Ú 254 14.1 XML¼Æ¾ÚÃþ«¬ 255 14.1.1 Ãþ«¬¤ÆXML©M «DÃþ«¬¤ÆXML 259 14.1.2 XML¬[ºc 260 14.1.3 XML¦C©MÅܶq 262 14.1.4 XML°Ñ¼Æ©Mªð¦^È 263 14.2 XML¼Æ¾ÚÃþ«¬¤èªk 265 14.2.1 XPath 265 14.2.2 value() 265 14.2.3 nodes()¤èªk 266 14.2.4 exist() 266 14.2.5 query()©Mmodify() 266 14.3 FOR XML 267 14.3.1 AUTO 267 14.3.2 RAW 270 14.3.3 EXPLICIT 271 14.3.4 PATH 272 14.4 XQuery»PFLWOR¾Þ§@ 274 14.5 ¤pµ² 275 ²Ä15³¹ ¤À¥¬¦¡¬d¸ßªº°õ¦æ 276 15.1 ¤À¥¬¦¡¬d¸ß·§z 276 15.2 ¤À¥¬¦¡¬d¸ßªº¶}µo 284 15.2.1 ¤À¥¬¦¡¬d¸ß©MSSMS 284 15.2.2 ¤À¥¬¦¡µø¹Ï 284 15.2.3 ¨Ï¥Î¤À¥¬¦¡¨Æ°È 287 15.3 ©Ê¯à¨Æ¶µ 289 15.3.1 Àu¤Æ¤À¥¬¦¡¬d¸ß 289 15.3.2 ¤À¤ù©MÁp¦X 290 15.4 ¤pµ² 291 ²Ä¢¼³¡¤À ¨Ï¥ÎT-SQL½sµ{ ²Ä16³¹ ¨Ï¥ÎT-SQL½sµ{ 295 16.1 Transact-SQL°ò¦ 295 16.1.1 T-SQL§å³B²z 296 16.1.2 T-SQL®æ¦¡¤Æ 297 16.2 ¾Þ§@Åܶq 298 16.2.1 ÅܶqÀq»{È©M§@¥Î°ì 298 16.2.2 ¨Ï¥ÎSET©R¥O©M SELECT©R¥O 299 16.2.3 ¼W¶qÅܶq 300 16.2.4 ±ø¥ó¿ï¾Ü 301 16.2.5 ¦bSQL¬d¸ß¤¤¨Ï¥ÎÅܶq 301 16.2.6 ¦h«½áÈÅܶq 302 16.3 ¹Lµ{¬y 303 16.3.1 ¨Ï¥Î±ø¥óT-SQLªº IF©R¥O 303 16.3.2 ¨Ï¥ÎWHILE´`Àô 305 16.3.3 ¨Ï¥ÎGOTO©R¥O ²¾°Ê¨ì¼Ðñ 306 16.4 ³q¹L¥N½X¤ÀªRSQL Server 306 16.4.1 °ÊºAºÞ²z¹ï¶H 306 16.4.2 sp_help 307 16.4.3 ¨t²Î¨ç¼Æ 308 16.5 Á{®Éªí©MªíÅܶq 308 16.5.1 ¥»¦aÁ{®Éªí 308 16.5.2 ¥þ§½Á{®Éªí 309 16.5.3 ªíÅܶq 310 16.6 SQL Server 2012¤¤Ãö¤_ T-SQLªº·s¼W¤º®e 311 16.6.1 ½Õ¸Õ¼W±j 311 16.6.2 ¤¸¼Æ¾Úµo²{ 311 16.6.3 OFFSET©MFETCH 312 16.7 ¿ù»~³B²z 313 16.7.1 ¿ò¯d¿ù»~³B²z 314 16.7.2 RAISERROR 315 16.7.3 TRY¡KCATCH 318 16.7.4 T-SQLP©R¿ù»~ 323 16.8 §å¶q¾Þ§@ 323 16.8.1 §å¶q´¡¤J 324 16.8.2 BCP 326 16.9 ¤pµ² 326 ²Ä17³¹ ¦sÀx¹Lµ{ªº¶}µo 327 17.1 ºÞ²z¦sÀx¹Lµ{ 328 17.1.1 ³Ð«Ø¡B§ó§ï©M§R°£ 328 17.1.2 ¬d¬Ý¦sÀx¹Lµ{ 329 17.1.3 ¥[±K¦sÀx¹Lµ{¥N½X 330 17.1.4 °õ¦æ¦sÀx¹Lµ{ 331 17.1.5 ¨t²Î¦sÀx¹Lµ{ 331 17.2 §â¼Æ¾Ú¶Ç»¼¨ì¦sÀx¹Lµ{ 332 17.2.1 ¿é¤J°Ñ¼Æ 332 17.2.2 ´£¨Ñ¦Cªí©Mªí§@¬° ¦sÀx¹Lµ{ªº¿é¤J°Ñ¼Æ 334 17.3 ±q¦sÀx¹Lµ{¤¤ªð¦^¼Æ¾Ú 338 17.3.1 ¿é¥X°Ñ¼Æ 338 17.3.2 RETURN©R¥Oªº¹B¥Î 339 17.3.3 µ²ªG¶° 340 17.3.4 ªð¦^¼Æ¾Úªº¸ô®|©MS³ò 342 17.4 ¤pµ² 343 ²Ä18³¹ ºc«Ø¥Î¤á©w¸qªº¨ç¼Æ 344 18.1 ¼Ð¶q¨ç¼Æ 345 18.1.1 ²z¸Ñ¨î 345 18.1.2 ³Ð«Ø¼Ð¶q¨ç¼Æ 346 18.1.3 ½Õ¥Î¼Ð¶q¨ç¼Æ 347 18.2 ¤ºÁpªíȨç¼Æ 347 18.2.1 ³Ð«Ø¤ºÁpªíȨç¼Æ 348 18.2.2 ½Õ¥Î¤ºÁpªíȨç¼Æ 348 18.2.3 ¨Ï¥Î°Ñ¼Æ 349 18.2.4 ±N¥Î¤á©w¸q¨ç¼Æ ¬Û¤¬ÃöÁp 350 18.2.5 ¨Ï¥Î¬[ºc¸j©w³Ð«Ø¨ç¼Æ 350 18.3 ¦h»y¥yªíȨç¼Æ 351 18.3.1 ³Ð«Ø¦h»y¥yªíȨç¼Æ 351 18.3.2 ½Õ¥Î¨ç¼Æ 352 18.4 ¥Î¤á©w¸q¨ç¼Æªº³Ì¨Î¹ê½î 353 18.4.1 ©Ê¯à³Ì¤j¤Æ 353 18.4.2 ¨Ï¥Î¤@Pªº©R¦W¬ù©w 353 18.5 ¤pµ² 353 ²Ä¢½³¡¤À ¥ø·~¼Æ¾ÚºÞ²z ²Ä19³¹ °t¸mSQL Server 357 19.1 ³]¸m¿ï¶µ 357 19.1.1 °t¸mªA°È¾¹ 358 19.1.2 °t¸m¼Æ¾Ú®w 361 19.1.3 °t¸m³s±µ 362 19.1.4 ¥~³òÀ³¥Î°t¸m¾¹¤è± 363 19.2 °t¸m¿ï¶µ 363 19.2.1 Åã¥Ü°ª¯Å¿ï¶µ 363 19.2.2 ±Ò°Ê/°±¤î°t¸mÄÝ©Ê 365 19.2.3 ¤º¦s°t¸mÄÝ©Ê 368 19.2.4 ³B²z¾¹°t¸mÄÝ©Ê 372 19.2.5 ¦w¥þ°t¸mÄÝ©Ê 377 19.2.6 ³s±µ°t¸mÄÝ©Ê 380 19.2.7 °ª¯ÅªA°È¾¹°t¸mÄÝ©Ê 385 19.2.8 °t¸m¼Æ¾Ú®w¦Û°Ê¿ï¶µ 388 19.2.9 ´å¼Ð°t¸mÄÝ©Ê 390 19.2.10 SQL ANSI°t¸mÄÝ©Ê 392 19.2.11 IJµo¾¹°t¸mÄÝ©Ê 398 19.2.12 ¼Æ¾Ú®wª¬ºA°t¸mÄÝ©Ê 398 19.2.13 «ì´_°t¸mÄÝ©Ê 400 19.3 ¤pµ² 403 ²Ä20³¹ °ò¤_µ¦²¤ªººÞ²z 404 20.1 ©w¸qµ¦²¤ 404 20.1.1 ºÞ²z¤è± 406 20.1.2 °·±d±ø¥ó 407 20.1.3 ³Ð«Øµ¦²¤ 409 20.2 µû¦ôµ¦²¤ 413 20.3 ¤pµ² 414 ²Ä21³¹ ³Æ¥÷©M«ì´_p¹º 415 21.1 «ì´_·§©À 416 21.2 «ì´_¼Ò«¬ 417 21.2.1 ²³æ«ì´_¼Ò«¬ 417 21.2.2 §¹¾ã«ì´_¼Ò«¬ 418 21.2.3 §å¶q¤é§Ó«ì´_¼Ò«¬ 419 21.2.4 ³]¸m«ì´_¼Ò«¬ 420 21.2.5 קï«ì´_¼Ò«¬ 420 21.3 ³Æ¥÷¼Æ¾Ú®w 421 21.3.1 ³Æ¥÷¥Ø¼Ð 421 21.3.2 ³Æ¥÷½ü´« 421 21.3.3 ¥ÎManagement Studio °õ¦æ³Æ¥÷ 421 21.3.4 ¥Î¥N½X³Æ¥÷¼Æ¾Ú®w 423 21.3.5 ¥Î¥N½XÅçÃҳƥ÷ 426 21.4 ¨Ï¥Î¨Æ°È¤é§Ó 426 21.4.1 ¨Æ°È¤é§Ó¤º 426 21.4.2 ³Æ¥÷¨Æ°È¤é§Ó 428 21.4.3 ºIÂ_¤é§Ó 429 21.4.4 ¨Æ°È¤é§Ó©M²³æ«ì´_ ¼Ò«¬ 429 21.5 «ì´_¾Þ§@ 429 21.5.1 ÀË´ú°ÝÃD 430 21.5.2 «ì´_¶¶§Ç 430 21.5.3 ¥ÎManagement Studio °õ¦æÁÙì 431 21.5.4 ÁÙìÓ§O¶± 433 21.5.5 ³q¹LT-SQL¥N½XÁÙì 434 21.6 ¨t²Î¼Æ¾Ú®w«ì´_ 438 21.6.1 master¼Æ¾Ú®w 438 21.6.2 msdb¨t²Î¼Æ¾Ú®w 440 21.7 °õ¦æ§¹¥þ«ì´_ 440 21.8 ¤pµ² 441 ²Ä22³¹ ºûÅ@¼Æ¾Ú®w 442 22.1 DBCC©R¥O 442 22.1.1 ¼Æ¾Ú®w§¹¾ã©Ê 444 22.1.2 ¼Æ¾Ú®w¤å¥ó¤j¤p 452 22.1.3 ¨ä¥LDBCC©R¥O 456 22.2 ºÞ²z¼Æ¾Ú®wºûÅ@ 457 22.2.1 p¹º¼Æ¾Ú®wºûÅ@ 457 22.2.2 ºûÅ@p¹º 457 22.2.3 ©R¥O¦æºûÅ@ 462 22.2.4 ºÊ±±¼Æ¾Ú®wºûÅ@ 462 22.3 ¤pµ² 463 ²Ä23³¹ ¶Ç¿é¼Æ¾Ú®w 464 23.1 Copy Database Wizard 465 23.2 ¨Ï¥ÎSQL¸}¥» 467 23.3 ¤ÀÂ÷©Mªþ¥[ 470 23.4 Import and Export Wizard 472 23.5 ¼Æ¾Ú¼hÀ³¥Îµ{§Ç(DAC) 474 23.6 ¤pµ² 475 ²Ä24³¹ ¼Æ¾Ú®w§Ö·Ó 477 24.1 ¼Æ¾Ú®w§Ö·Óªº¤u§@ì²z 478 24.1.1 ¼Æ¾Ú®w§Ö·Óªº¾÷¨î 478 24.1.2 ²Ä¤@¦¸¼g®É´_¨î 478 24.2 ¨Ï¥Î¼Æ¾Ú®w§Ö·Ó 479 24.2.1 ³Ð«Ø¼Æ¾Ú®w§Ö·Ó 479 24.2.2 ¬d¸ß¼Æ¾Ú®w§Ö·Ó 481 24.2.3 §R°£¼Æ¾Ú®w§Ö·Ó 482 24.2.4 ¦^ºu¼Æ¾Ú®w§Ö·Ó 482 24.3 ¤pµ² 484 ²Ä25³¹ ¨Ï¥ÎService Broker¶i¦æ ²§¨B®ø®§¶Ç¿é 485 25.1 °t¸m®ø®§¶¤¦C 486 25.2 ¨Ï¥Î¹ï¸Ü 488 25.2.1 ±N®ø®§µo°e¨ì¶¤¦C 488 25.2.2 ±µ¦¬®ø®§ 489 25.3 SQL Server 2012¤¤Service Brokerªº·s¼W¥\¯à 491 25.3.1 ®ø®§¦h¼½ 491 25.3.2 AlwaysOn¤ä«ù 491 25.3.3 ¦³®`®ø®§³B²z 492 25.3.4 ®ø®§±Æ¶¤®É¶¡ 492 25.4 ºÊ±±Service Broker©M ±Æ°£¬G»Ù 492 25.5 ¤pµ² 493 ²Ä26³¹ ¤é§Ó¶Ç°e 494 26.1 ¥i¥Î©Ê´ú¸Õ 495 26.2 ·Å³Æ¥Î¥i¥Î©Ê 495 26.3 ©w¸q¤é§Ó¶Ç°e 496 26.4 Àˬd¤é§Ó¶Ç°e°t¸m 504 26.5 ºÊµø¤é§Ó¶Ç°e 505 26.6 קï©Î§R°£¤é§Ó¶Ç°e 506 26.7 ¤Á´«¨¤¦â 508 26.8 ¤pµ² 509 ²Ä27³¹ ¼Æ¾Ú®wÃè¹³ 510 27.1 ¼Æ¾Ú®wÃè¹³·§z 511 27.2 ©w¸q©M°t¸m¼Æ¾Ú®wÃè¹³ 512 27.3 Àˬd¼Æ¾Ú®wÃè¹³°t¸m 520 27.4 ºÊ±±¼Æ¾Ú®wÃè¹³ 522 27.4.1 ¨Ï¥ÎDatabase Mirroring MonitorºÊ±± 522 27.4.2 ¨Ï¥ÎSystem MonitorºÊ±± 525 27.4.3 ¨Ï¥ÎSQL Server Profiler ºÊ±± 525 27.5 ¼È°±©Î§R°£¼Æ¾Ú®wÃè¹³ 526 27.6 ¨¤¦â¤Á´« 526 27.7 °ª¥i¥Î©Ê/AlwaysOn 528 27.7.1 n¨D©M«e´£±ø¥ó 528 27.7.2 °t¸mAlwaysOn Availability Groups 529 27.7.3 ºÊ±±AlwaysOn Availability Groups 536 27.8 ¤pµ² 537 ²Ä28³¹ ´_¨î¼Æ¾Ú 538 28.1 ¦bªA°È¾¹¤§¶¡²¾°Ê¼Æ¾Ú 538 28.1.1 §å¶q´_¨îµ{§Ç 539 28.1.2 SSIS 539 28.1.3 ¤Àµo¦¡¨Æ°È 539 28.1.4 IJµo¾¹ 539 28.1.5 Copy Database Wizard 539 28.1.6 ³Æ¥÷©MÁÙì 539 28.1.7 ¤é§Ó¶Ç°e 540 28.1.8 ¼Æ¾Ú®wÃè¹³ 540 28.2 ´_¨îªº·§©À 540 28.2.1 ´_¨îªºÃþ«¬ 540 28.2.2 ´_¨î¥N²z 541 28.2.3 ¨Æ°È¤@P©Ê 542 28.3 °t¸m´_¨î 542 28.3.1 ³Ð«Øµo¥¬ªA°È¾¹©M ¤ÀµoªA°È¾¹ 542 28.3.2 ¨Ï¥Î»·µ{¤ÀµoªA°È¾¹ 543 28.3.3 ³Ð«Ø¤@Ó§Ö·Ó/¨Æ°Èµo¥¬ 544 28.3.4 ³Ð«Ø¨Æ°È/§Ö·Óµo¥¬ªº ±À°eq¾\ 546 28.3.5 ³Ð«Ø¨Æ°È/§Ö·Óµo¥¬ªº ½Ð¨Dq¾\ 547 28.3.6 ³Ð«Ø¹ïµ¥©Ý¼³ 548 28.3.7 ³Ð«Ø¤@Ó¦X¦}µo¥¬ 548 28.3.8 Web¦P¨B 549 28.4 ¤pµ² 550 ²Ä29³¹ ¸s¶° 551 29.1 ¸s¶°ªº¥\¯à 551 29.1.1 °ª¥i¥Î©Ê©M¥i¦ùÁY©Ê 551 29.1.2 ¦b½uªº§t¸q 552 29.1.3 ¸s¶°ªº¤u§@ì²z 552 29.2 °t¸m¸s¶° 553 29.2.1 °t¸mWindows Server 2008/2008R2ªº¸s¶° 553 29.2.2 §âSQL Server 2012 ¦w¸Ë¬°¸s¶°¹ê¨Ò 558 29.2.3 ´ú¸Õ¬G»ÙÂಾ 565 29.3 ¤pµ² 566 ²Ä30³¹ ¥ÎPowerShell°t¸m©M ºÞ²zSQL Server 567 30.1 ¨Ï¥ÎPowerShellªºì¦] 567 30.2 PowerShell°ò¥»ª¾ÃÑ 568 30.2.1 »y¨¥¯S©Ê 568 30.2.2 ³Ð«Ø¸}¥» 573 30.3 SQL Server PowerShellÂX®i 577 30.3.1 ¾É¤J¼Ò¶ô 577 30.3.2 SQL PSDrive¡X¡X SQLSERVER 577 30.3.3 SQL cmdlet 578 30.4 ³q¹LSMO»PSQL Server ³q«H 580 30.4.1 SQL ServerºÞ²z¹ï¶H 580 30.4.2 ADO.NET 583 30.5 ½s¼gSQL Server¥ô°È¸}¥» 585 30.5.1 ºÞ²z¥ô°È 585 30.5.2 °ò¤_¼Æ¾Úªº¥ô°È 588 30.6 ¤pµ² 589 ²Ä31³¹ ºÞ²zWindows Azure SQL Database ¤¤ªº¼Æ¾Ú 590 31.1 Azure SQL Database·§z 590 31.2 ºÞ²zWindows Azure SQL Database 590 31.2.1 SQL Server Management Studio 591 31.2.2 Windows Azure SQL DatabaseºÞ²z¾¹ 592 31.2.3 ¦bSQL Database¤¤³Ð«Ø ¼Æ¾Ú®w 592 31.3 °ª¥i¥Î©Ê©M¥i¦ùÁY©Ê 593 31.3.1 °ª¥i¥Î©Ê 593 31.3.2 ¥i¦ùÁY©Ê 594 31.4 §â¼Æ¾Ú¾E²¾¨ì SQL Database¤¤ 594 32.4.1 ¥Í¦¨¸}¥»¦V¾É 595 31.4.2 SQL Server Integration Services 601 31.4.3 ¨Ï¥Îbcp¹ê¥Î¤u¨ã 608 31.5 ¤pµ² 610 ²Ä¢¾³¡¤À «OÅ@SQL Serverªº¦w¥þ ²Ä32³¹ SQL Server¤¤ªº¨¥÷ ÅçÃÒÃþ«¬ 613 32.1 Windows¨¥÷ÅçÃÒ 615 32.2 SQL¨¥÷ÅçÃÒ 615 32.3 SQL©MWindows¨¥÷ ÅçÃÒ¤§¶¡ªº°Ï§O 616 32.4 Kerberos©MWindows ¨¥÷ÅçÃÒ©e¦« 616 32.5 ¤pµ² 617 ²Ä33³¹ ±ÂÅv¦w¥þ¹ï¶H 618 33.1 ÅvÃì 618 33.2 ¹ï¶H©Ò¦³Åv 619 33.3 ¦w¥þ¹ï¶HªºÅv 619 33.4 ¹ï¶H¦w¥þ 620 33.4.1 ¥Î¤á¦Û©w¸q¼Æ¾Ú®w¨¤¦â 620 33.4.2 ¹ï¶HÅv 620 33.4.3 ¥Î¥N½X±Â¤©¹ï¶HÅv 621 33.4.4 ¥Î¥N½XºM®ø©M©Úµ´ ¹ï¶HÅv 622 33.4.5 ¤½¦@¨¤¦â 623 33.4.6 ¥Î¥N½XºÞ²z¨¤¦â 623 33.4.7 ¤À¼h¨¤¦âµ²ºc 624 33.4.8 ¹ï¶H¦w¥þ©MManagement Studio 624 33.5 ¤@ӥܨҦw¥þ¼Ò«¬ 625 33.6 µø¹Ï©M¦w¥þ 625 33.7 ¤pµ² 626 ²Ä34³¹ ¼Æ¾Ú¥[±K 627 34.1 ¼Æ¾Ú¥[±K²¤¶ 627 34.1.1 ±KÆ_ªº¼h¦¸µ²ºc 628 34.1.2 ¥ÎT-SQL¥[±K 628 34.1.3 ¥Î¹ïºÙ±KÆ_¥[±K 630 34.1.4 ¨Ï¥Î«D¹ïºÙ±KÆ_ 631 34.1.5 ¨Ï¥ÎÃÒ®Ñ 632 34.2 ¤pµ² 632 ²Ä35³¹ ¦æ¯Å¦w¥þ©Ê 633 35.1 Securityªí 633 35.2 ¤À°tÅv 635 35.2.1 ¤À°t¦w¥þ©Ê 635 35.2.2 ³B²z¦w¥þ¯Å§Oªº§ó·s 638 35.3 ÀˬdÅv 640 35.3.1 ¦w¥þÀˬd¦sÀx¹Lµ{ 640 35.3.2 ¦w¥þÀˬd¨ç¼Æ 641 35.3.3 ¨Ï¥ÎWindowsµn¿ý 642 35.3.4 ¦w¥þÀˬdIJµo¾¹ 644 35.4 ¤pµ² 644 ²Ä¢¿³¡¤À ºÊµø©M¼fp ²Ä36³¹ IJµo¾¹ªº³Ð«Ø 647 36.1 IJµo¾¹°ò¦ 647 36.1.1 ¨Æ°È¬y 648 36.1.2 IJµo¾¹ªº³Ð«Ø 648 36.1.3 AFTERIJµo¾¹ 649 36.1.4 INSTEAD OFIJµo¾¹ 650 36.1.5 IJµo¾¹¨î 651 36.1.6 ¸T¥ÎIJµo¾¹ 651 36.1.7 ¦C¥XIJµo¾¹ 652 36.1.8 IJµo¾¹©M¦w¥þ©Ê 652 36.2 ³B²z¨Æ°È 652 36.2.1 ½T©w¤w§ó·sªº¦C 653 36.2.2 inserted©MdeletedÅÞ¿èªí 654 36.2.3 ¶}µo¤ä«ù¦h¦æªºÄ²µo¾¹ 655 36.3 ¦hÓIJµo¾¹¤§¶¡ªº¥æ¤¬ 656 36.3.1 IJµo¾¹ªº²Õ´ 657 36.3.2 ´O®MIJµo¾¹ 657 36.3.3 »¼ÂkIJµo¾¹ 658 36.3.4 INSTEAD OFIJµo¾¹©M AFTERIJµo¾¹¤@°_¨Ï¥Î 660 36.3.5 ¦hÓAFTERIJµo¾¹ 660 36.4 ¨Æ°È»E¦X³B²z 660 36.4.1 ®w¦s¨Æ°ÈIJµo¾¹ 661 36.4.2 ®w¦sIJµo¾¹ 662 36.5 DDLIJµo¾¹ 664 36.6 DDLIJµo¾¹ªººÞ²z 664 36.6.1 ³Ð«Ø©M§ó§ïDDLIJµo¾¹ 664 36.6.2 IJµo¾¹ªº§@¥Î°ì 665 36.6.3 DDLIJµo¾¹©M¦w¥þ©Ê 666 36.6.4 ±Ò¥Î©M¸T¥ÎDDLIJµo¾¹ 666 36.6.5 §R°£DDLIJµo¾¹ 667 36.7 DDLIJµo¾¹ªº¶}µo 667 36.7.1 EventData()¨ç¼Æ 667 36.7.2 ÁקK¼Æ¾Ú®w¹ï¶Hªº§ó§ï 668 36.8 ¤pµ² 669 ²Ä37³¹ ©Ê¯àºÊµø¾¹©MPAL 670 37.1 ¨Ï¥ÎPerfMon 670 37.1.1 ¨t²ÎºÊµø¾¹ 670 37.1.2 Data Collector Set 673 37.1.3 ¨Ï¥ÎPowerShell³X°Ý ©Ê¯àp¼Æ¾¹ 674 37.2 ¤pµ² 676 ²Ä38³¹ ¨Ï¥ÎProfiler©MSQL Trace 677 38.1 SQL Server Profilerªº¥\¯à 677 38.2 ¹B¦æProfiler 677 38.2.1 ©w¸q·sªº¸òÂÜ 678 38.2.2 ¿ï¾Ü¨Æ¥ó©M¼Æ¾Ú¦C 678 38.2.3 ¿z¿ï¨Æ¥ó 680 38.2.4 ²Õ´¦C 680 38.2.5 ¹B¦æ¸òÂÜ 681 38.2.6 ¨Ï¥Î¸òÂܤå¥ó 681 38.2.7 ¶°¦¨©Ê¯àºÊµø¾¹¼Æ¾Ú 681 38.3 ¨Ï¥ÎSQL Trace 682 38.4 ¤pµ² 684 ²Ä39³¹ µ¥«Ýª¬ºA 685 39.1 SQL Server OS 685 39.2 ¬d¬Ýµ¥«Ýª¬ºA²Îp«H®§ 686 39.2.1 °õ¦æ½Ð¨D 686 39.2.2 µ¥«Ýª¬ºA²Îp«H®§ 686 39.2.3 µ¥«Ý½Ð¨D 687 39.3 ±`¨£ªº¬õºXµ¥«ÝÃþ«¬ 687 39.4 ¦¬¶°µ¥«Ý¼Æ¾Úªº¨ä¥L¤è¦¡ 688 39.5 ¤pµ² 688 ²Ä40³¹ Extended Events 689 40.1 Extended Events¹ï¶H¼Ò«¬ 689 40.1.1 ¥] 689 40.1.2 ¨Æ¥ó 690 40.1.3 °Ê§@ 690 40.1.4 ¥Ø¼Ð 691 40.1.5 ¿×µü 691 40.1.6 ¬M®g 691 40.1.7 ·|¸Ü 692 40.1.8 ³q¹D 692 40.2 system_health·|¸Ü 692 40.3 Extended Events Profiler 692 40.4 ¤pµ² 694 ²Ä41³¹ ¼Æ¾Ú§ó§ïªº¸òÂÜ©M®·Àò 695 41.1 °t¸mChange Tracking 695 41.1.1 ±Ò¥Î¼Æ¾Ú®w 696 41.1.2 ¦Û°Ê²M²z 696 41.1.3 ±Ò¥Îªí 697 41.1.4 ¤º³¡ªí 698 41.2 ¬d¸ßChange Tracking 699 41.2.1 ª©¥»¸¹ 699 41.2.2 ¦æÅܧó 700 41.3 §R°£Change Tracking 701 41.4 Change Data Capture 702 41.5 SQL Server 2012¤¤ªº ·s¼W¥\¯à 703 41.6 ±Ò¥ÎCDC 703 41.6.1 ±Ò¥Î¼Æ¾Ú®w 703 41.6.2 ±Ò¥Îªí 704 41.7 ¨Ï¥ÎChange Data Capture 705 41.7.1 Àˬd¤é§Ó§Ç¸¹ 705 41.7.2 ¬d¸ßÅܧóªí 706 41.7.3 ¬d¸ßÐä§ó§ï 708 41.7.4 ¡¥NÅܧóªí 710 41.8 §R°£Change Data Capture 710 41.9 ¤pµ² 711 ²Ä42³¹ SQL Audit 712 42.1 SQL Audit§Þ³N·§z 712 42.2 ³Ð«ØAudit¹ï¶H 713 42.2.1 ©w¸q¥Ø¼Ð 714 42.2.2 ¨Ï¥ÎT-SQL 714 42.2.3 ±Ò¥Î/¸T¥Î¼fp 715 42.3 Server Audit Specification 715 42.3.1 ²K¥[¾Þ§@ 716 42.3.2 ¥ÎT-SQL³Ð«Ø 716 42.3.3 קïServer Audit Specification 716 42.4 Database Audit Specification 716 42.5 ¬d¬Ý¼fp½u¯Á 717 42.6 ¤pµ² 718 ²Ä43³¹ ºÞ²z¼Æ¾ÚÜ®w 719 43.1 ¨Ï¥ÎºÞ²z¼Æ¾ÚÜ®w 719 43.2 °t¸mMDW 720 43.3 «Ø¥ß¼Æ¾Ú¶°¦X 723 43.4 ¬d¬ÝMDW³øªí 724 43.4.1 ºÏ½L¨Ï¥Î±¡ªp¶×Á` 724 43.4.2 ªA°È¾¹¬¡°Ê¾ú¥v³øªí 725 43.4.3 ¬d¸ß²Îp«H®§³øªí 726 43.5 ³Ð«Ø©w¨îªº¼Æ¾Ú¦¬¶°¾¹¶°¦X 726 43.6 ¤pµ² 728 ²Ä¢À³¡¤À ©Ê¯à½Õ¾ã©MÀu¤Æ ²Ä44³¹ ¸ÑÄÀ¬d¸ß°õ¦æp¹º 731 44.1 ¬d¬Ý¬d¸ß°õ¦æp¹º 732 44.1.1 ¦ôp©M¹ê»Ú¬d¸ß°õ¦æp¹º 732 44.1.2 ¾\Ū°õ¦æp¹º 732 44.1.3 ¨Ï¥ÎShowplan©M STATISTICS PROFILE 733 44.1.4 SQL Profilerªº°õ¦æp¹º 734 44.2 ²z¸Ñ¬d¸ß°õ¦æp¹º 735 44.3 ¤pµ² 736 ²Ä45³¹ ¯Á¤Þµ¦²¤ 737 45.1 ¯Á¤ÞªºÃÀ³N 737 45.2 ¯Á¤Þ°ò¦ 738 45.2.1 B-¾ð¯Á¤Þ 738 45.2.2 »E¶°¯Á¤Þ 738 45.2.3 «D»E¶°¯Á¤Þ 739 45.2.4 ´_¦X¯Á¤Þ 740 45.2.5 °ß¤@¯Á¤Þ©M¬ù§ô 740 45.2.6 ¶±¤À¹j°ÝÃD 740 45.2.7 ¯Á¤Þ¿ï¾Ü©Ê 741 45.2.8 µL§Çªº°ï 742 45.2.9 ¬d¸ß¾Þ§@ 742 45.3 ¬d¸ß¸ô®| 743 45.3.1 ¬d¸ß¸ô®|1¡G´£¨ú ©Ò¦³¼Æ¾Ú 745 45.3.2 ¬d¸ß¸ô®|2¡G»E¶° ¯Á¤Þ¬d§ä 745 45.3.3 ¬d¸ß¸ô®|3¡GS³ò ¬d§ä¬d¸ß 745 45.3.4 ¬d¸ß¸ô®|4¡G¥Î«DÁä ¦C¿z¿ï 747 45.3.5 ¬d¸ß¸ô®|5¡G®Ññ¬d§ä 748 45.3.6 ¬d¸ß¸ô®|6¡GÂл\¯Á¤Þ 749 45.3.7 ¬d¸ß¸ô®|7¡G¥Î2ÓNC ¯Á¤Þ¨Ó¿z¿ï 752 45.3.8 ¬d¸ß¸ô®|8¡G¥Î¦³§Çªº ´_¦X¯Á¤Þ¿z¿ï 753 45.3.9 ¬d¸ß¸ô®|9¡G¥ÎµL§Çªº ´_¦X¯Á¤Þ¿z¿ï 753 45.3.10 ¬d¸ß¸ô®|10¡GNon- SARG-ableªí¹F¦¡ 754 45.4 ¥þ±ªº¯Á¤Þµ¦²¤ 755 45.4.1 ¼ÐÃÑ«n¬d¸ß 755 45.4.2 ¿ï¾Ü»E¶°¯Á¤Þ 756 45.4.3 ³Ð«Ø°ò¯Á¤Þ 757 45.5 ¯S®í¯Á¤Þ 757 45.5.1 ¿z¿ï¯Á¤Þ 757 45.5.2 ¯Á¤Þµø¹Ï 758 45.5.3 Columnstore¯Á¤Þ 760 45.6 ¤pµ² 760 ²Ä46³¹ ³Ì¤j«×¦a«¥Î¬d¸ßp¹º 762 46.1 ¬d¸ß½sĶ 762 46.1.1 Query Optimizer 762 46.1.2 ¬d¬ÝPlan Cache 763 46.1.3 ¬d¸ßp¹ºªº¥Í¦s´Á 764 46.1.4 °õ¦æ¬d¸ßp¹º 764 46.2 ¬d¸ß«½sĶ 764 46.3 ¤pµ² 765 ²Ä47³¹ ºÞ²z¨Æ°È¡BÂê©w©Mªý¶ë 766 47.1 ACIDÄÝ©Ê 767 47.1.1 ì¤l©Ê 767 47.1.2 ¤@P©Ê 767 47.1.3 ¹jÂ÷©Ê 767 47.1.4 «ù¤[©Ê 768 47.2 ¨Æ°Èªº½sµ{ 768 47.2.1 ÅÞ¿è¨Æ°È 768 47.2.2 Xact_State()¨ç¼Æ 769 47.2.3 Xact_Abort 769 47.2.4 ´O®M¨Æ°È 770 47.2.5 Áô¦¡¨Æ°È 770 47.2.6 «O¦sÂI 771 47.3 Àq»{ªºÂê©w©Mªý¶ë¦æ¬° 771 47.4 ºÊ±±Âê©w©Mªý¶ë 773 47.4.1 ¨Ï¥ÎManagement Studio ³øªí¬d¬Ýªý¶ë 773 47.4.2 ¨Ï¥ÎActivity Monitor ¬d¬Ýªý¶ë 774 47.4.3 ¨Ï¥ÎProfiler 775 47.4.4 ¨Ï¥Î°ÊºAºÞ²zµø¹Ï¬d¸ßÂê 775 47.5 ¦ºÂê 776 47.5.1 ³Ð«Ø¦ºÂê 777 47.5.2 ¦Û°ÊÀË´ú¦ºÂê 779 47.5.3 ³B²z¦ºÂê 779 47.5.4 ³Ì¤p¤Æ¦ºÂê 780 47.6 ²z¸ÑSQL ServerÂê©w 781 47.6.1 Âê²É«× 781 47.6.2 Âê¼Ò¦¡ 781 47.6.3 ±±¨îÂê©w¶W®É 783 47.6.4 Âê©w«ùÄò®É¶¡ 783 47.6.5 ¯Á¤Þ¯ÅªºÂê©w¨î 783 47.7 ¨Æ°È¹jÂ÷¯Å§O 784 47.7.1 ³]¸m¨Æ°È¹jÂ÷¯Å§O 785 47.7.2 ¯Å§O1¡X¡XRead Uncommitted©MŦŪ¨ú 786 47.7.3 ¯Å§O2¡X¡XRead Committed 787 47.7.4 ¯Å§O3¡X¡XRepeatable Read 787 47.7.5 ¯Å§O4¡X¡XSerializable 790 47.7.6 §Ö·Ó¹jÂ÷ 793 47.7.7 ¨Ï¥ÎÂê©w´£¥Ü 795 47.8 À³¥Îµ{§ÇÂê 796 47.9 À³¥Îµ{§ÇÂê©w³]p 797 47.9.1 ¹ê²{¼ÖÆ[Âê©w 797 47.9.2 ¥á¥¢§ó·s 797 47.10 ¨Æ°È¤é§ÓªºÅé¨tµ²ºc 798 47.10.1 ¨Æ°È¤é§Ó§Ç¦C 798 47.10.2 ¨Æ°È¤é§Ó«ì´_ 800 47.11 ¨Æ°È©Ê¯àµ¦²¤ 801 47.12 ¤pµ² 802 ²Ä48³¹ ¼Æ¾ÚÀ£ÁY 803 48.1 ²z¸Ñ¼Æ¾ÚÀ£ÁY 803 48.1.1 ¼Æ¾ÚÀ£ÁYªºÀu¯ÊÂI 804 48.1.2 ¦æÀ£ÁY 805 48.1.3 ¶±À£ÁY 805 48.1.4 À£ÁY§Ç¦C 806 48.2 À³¥Î¼Æ¾ÚÀ£ÁY 807 48.2.1 ½T©w·í«eÀ£ÁY³]¸m 807 48.2.2 ¦ôp¼Æ¾ÚÀ£ÁY 807 48.2.3 ±Ò¥Î¼Æ¾ÚÀ£ÁY 808 48.2.4 ¼Æ¾ÚÀ£ÁYµ¦²¤ 809 48.3 ¤pµ² 810 ²Ä49³¹ ¤À°Ï 811 49.1 ¤À°Ïµ¦²¤ 811 49.2 ¤À°Ïµø¹Ï 812 49.3 ¤w¤À°Ïªí©M¯Á¤Þ 817 49.3.1 ³Ð«Ø¤å¥ó²Õ 818 49.3.2 ³Ð«Ø¤À°Ï¨ç¼Æ 820 49.3.3 ³Ð«Ø¤À°Ï¼Ò¦¡ 820 49.3.4 ³Ð«Ø¤À°Ïªí 821 49.3.5 ¬d¸ß¤À°Ïªí 822 49.3.6 קï¤À°Ïªí 822 49.3.7 ¤Á´«ªí 823 49.3.8 ºu°Ê¤À°Ï 825 49.3.9 µ¹¤w¤À°Ïªí«Ø¥ß¯Á¤Þ 826 49.3.10 §R°£¤À°Ï 826 49.4 ¤pµ² 826 ²Ä50³¹ Resource Governor 827 50.1 ¬ã¨sResource Governorªº °ò¦ª¾ÃÑ 827 50.1.1 ²z¸Ñ¸ê·½¦À 827 50.1.2 ¤u§@t¸ü²Õ 830 51.1.3 ¤ÀÃþ¾¹¨ç¼Æ 832 50.2 Resource Governorªº ©Ê¯àºÊ±± 833 50.3 µø¹Ï©M¨î 834 50.4 ¤pµ² 834 ²Ä¢Á³¡¤À °Ó ·~ ´¼ ¯à ²Ä51³¹ BI¼Æ¾Ú®w³]p 837 51.1 ¼Æ¾ÚÜ®w 837 51.2 ¨Ï¥Î¬P«¬¬[ºc³]p¼Æ¾ÚÜ®w 838 51.3 ¥Î³·¤ù«¬¬[ºc³]p¼Æ¾ÚÜ®w 839 51.4 ¦b¼Æ¾ÚÜ®w¤¤½T«O¤@P©Ê 839 51.5 ¥[¸ü¼Æ¾Ú 840 51.5.1 ¥[¸üºû«× 840 51.5.2 ¥[¸ü¨Æ¹êªí 842 51.5.3 קïºû«×¤¤ªº¼Æ¾Ú 842 51.6 ¤pµ² 843 ²Ä52³¹ ¦bIntegration Services¤¤ «Ø¥ß¡B³¡¸p©MºÞ²zETL ¤u§@¬y 844 52.1 SSISÀô¹Ò·§z 845 52.1.1 ¦bSQL Server Data Services¤¤³Ð«Ø°ò¥»ªº SSIS¥] 846 52.1.2 ¨Ï¥ÎUI§ï¶i¥\¯à¤è«K¦a °t¸m¤@Ӽƾڬy¥ô°È¤¤ªº ¥]¤¸¯À 848 52.2 SSISÀô¹Ò¸Ôz 852 52.2.1 ¨Ï¥Î³s±µºÞ²z¾¹ 852 52.2.2 ¨Ï¥Î±±¨î¬y¤¸¯À 854 52.2.3 ¨Ï¥Î¼Æ¾Ú¬y²Õ¥ó 858 52.2.4 ¨Ï¥Î°Ñ¼Æ©MÅܶq 863 52.2.5 Åܶq 864 52.2.6 ¨Ï¥ÎSSISªí¹F¦¡»y¨¥ 865 52.2.7 ¨Ï¥Î¥]ªº¤é§Ó°O¿ý 866 52.3 ³¡¸p¡B°õ¦æ¶µ¥Ø©M¥] 866 52.3.1 ¨Ï¥Î¥]³¡¸p¼Ò«¬ 866 52.3.2 ±q(ÂÂ)¥]¼Ò«¬Âà´«¬° ¶µ¥Ø¼Ò«¬ 867 52.3.3 ¨Ï¥Î¶µ¥Ø³¡¸p¼Ò«¬ 867 52.3.4 ¨Ï¥ÎSSISªA°È¾¹°õ¦æ ¶µ¥Ø©M¥] 868 52.4 ¤pµ² 870 ²Ä53³¹ ¦bAnalysis Services¤¤¨Ï¥Î MDXºc«Ø¦hºû¼Æ¾Ú¶° 871 53.1 Analysis Servicesªº§Ö³t±Ò°Ê 871 53.2 Analysis ServicesÅé¨tµ²ºc 872 53.2.1 ²Î¤@ºû«×¼Ò«¬ 872 53.2.2 ªA°È¾¹ 872 53.2.3 «È¤áºÝ 873 53.3 ºc«Ø¼Æ¾Ú®w 873 53.3.1 SQL Server Data Tools 873 53.3.2 ¼Æ¾Ú·½ 873 53.3.3 ¼Æ¾Ú·½µø¹Ï 874 53.3.4 ³Ð«Ø¦hºû¼Æ¾Ú¶° 877 53.4 ºû«× 877 53.4.1 ³Ð«Øºû«× 877 53.4.2 ±`³Wºû«×¤§¥~ªº¤º®e 880 53.4.3 ºû«×ªº²Ó¤Æ 880 53.5 ¦hºû¼Æ¾Ú¶° 881 53.5.1 ºû«×ªº¨Ï¥Î 883 53.5.2 Calculations¿ï¶µ¥d 883 53.5.3 KPI 884 53.5.4 °Ê§@ 884 53.5.5 ¤À°Ï 884 53.5.6 »E¦X¨ç¼Æªº³]p 885 53.5.7 ³zµø 886 53.6 ¼Æ¾Ú¦sÀx 887 53.7 ¦hºû¼Æ¾Ú¶°ªº³B²z 887 53.7.1 ³B²z¤èªk 888 53.7.2 ¨ä¥L¦Ò¼{ 888 53.7.3 ªÅȳB²z 889 53.7.4 ¥¼ª¾¦¨û 889 53.7.5 ¿ù»~°t¸m 889 53.8 ¤pµ² 889 ²Ä54³¹ °t¸m©MºÞ²zAnalysis Services 890 54.1 ¦w¸ËAnalysis Services 890 54.2 °t¸mAnalysis Servicesªº °ò¥»³]¸m 893 54.3 °ª¯ÅSSAS³¡¸p 894 54.4 ¨Ï¥ÎSQL Profilerµû¦ô ¬d¸ß©Ê¯à 895 54.5 ¤pµ² 896 ²Ä55³¹ ¨Ï¥ÎReporting Services ½s¼g³øªí 897 55.1 ³øªí½s¼gÀô¹Ò 897 55.1.1 SQL Server Data Tools(SSDT) ¤¤ªºReport Designer 898 55.1.2 Report Builder 898 55.1.3 Power View 898 55.2 ³øªíªº°ò¥»²Õ¦¨ 898 55.2.1 ¼Æ¾Ú·½ 898 55.2.2 ¼Æ¾Ú¶° 899 55.2.3 ³øªí©w¸q»y¨¥(RDL)¤å¥ó 899 55.3 ¥ÎReport Wizard«Ø¥ß³øªí 900 55.4 ±qÀY½s¼g³øªí 901 55.5 ¬ã¨sReport Designer 902 55.5.1 ³]p¬É± 902 55.5.2 Solution Explorer©M Properties 902 55.5.3 Report Data©MToolbox ±ªO 903 55.5.4 ¤å¥»®ØÄݩʵ¡¤f 904 55.6 ¨Ï¥ÎReporting Services ¥\¯àÅã¥Ü¼Æ¾Ú 905 55.6.1 ³Ð«ØMatrix³øªí 905 55.6.2 ³B²z¦hºû¼Æ¾Ú¶° 905 55.6.3 ¨Ï¥Î°Ñ¼Æ 907 55.6.4 ¨Ï¥ÎRS Expressions 909 55.7 ³]p³øªí¥¬§½ 909 55.7.1 ¿ï¾Ü³øªíÃþ«¬ 909 55.7.2 ¤À²Õ©M±Æ§Ç 910 55.7.3 ¨Ï¥Î¹Ïªí¤u¨ã 910 55.8 ¥ÎReport Builder«Ø¥ß³øªí 912 55.8.1 ¥ÎReport Builder ³Ð«Ø³øªí 912 55.8.2 ¨Ï¥ÎReport Gallery 914 55.9 ¤pµ² 915 ²Ä56³¹ °t¸m©MºÞ²zReporting Services 916 56.1 ¦w¸ËReporting Services 916 56.1.1 ¥»¾÷¼Ò¦¡ 916 56.1.2 SharePoint ¶°¦¨¼Ò¦¡ 917 56.2 ³¡¸pReporting Services³øªí 919 56.2.1 ¨Ï¥ÎSSDT³¡¸p³øªí 919
56.2.2 ¨Ï¥ÎReport Manager ³¡¸p³øªí¡X¡X¥»¾÷¼Ò¦¡ 920 56.2.3 ¦bSharePoint¤¤³¡¸p³øªí 920 56.3 ¥ÎReporting Services ºÞ²z¦w¥þ 922 56.3.1 ¦b¥»¾÷¼Ò¦¡¤UºÞ²z¨¤¦â 923 56.3.2 ¥Î¨¤¦âºÞ²z³X°ÝÅv 924 56.3.3 ºÞ²zq¾\ 926 56.3.4 ³Ð«Ø¼Æ¾ÚÅX°Êªºq¾\ 927 56.3.5 ¶°¦¨¼Ò¦¡¤Uªº Data Alerts 927 56.4 ¨aÃø«ì´_ 927 56.4.1 ³Æ¥÷¥Ø¿ý 928 56.4.2 ³Æ¥÷¹ïºÙ±KÆ_ 928 56.4.3 ÁÙìReporting Services 929 56.5 ¤pµ² 929 ²Ä57³¹ ¨Ï¥ÎAnalysis Services «õ±¸¼Æ¾Ú 930 57.1 ¼Æ¾Ú«õ±¸¹Lµ{ 930 57.2 ¨Ï¥ÎAnalysis Services«Ø¼Ò 931 57.2.1 ¼Æ¾Ú«õ±¸¦V¾É 931 57.2.2 «õ±¸¼Ò«¬ 932 57.2.3 ¼Ò«¬µû¦ô 933 57.3 ºâªk 936 57.3.1 ¨Mµ¦¾ð 936 57.3.2 ½u©Ê¦^Âk 937 57.3.3 »EÃþ¤ÀªR 937 57.3.4 §Ç¦C»EÃþ¤ÀªR 938 57.3.5 ¯«¸gºôµ¸ 938 57.3.6 ÅÞ¿è¦^Âk 938 57.3.7 Naive Bayes 939 57.3.8 ÃöÁp³W«h 940 57.3.9 ®É¶¡§Ç¦C 940 57.4 ¦hºû¼Æ¾Ú¶°¶°¦¨ 941 57.5 ¤pµ² 941 ²Ä58³¹ ³Ð«Ø©M³¡¸pBI»y¸q¼Ò«¬ 942 58.1 BI»y¸q¼Ò«¬ªº§t¸q 942
58.2 ¶}µoÀô¹Ò 943 58.3 ¨Ï¥ÎPowerPivot³Ð«Ø BI»y¸q¼Ò«¬ 945 58.4 ¥ÎPowerPivotÂX®iBI »y¸q¼Ò«¬ 948 58.4.1 ¦bPowerPivot¤¤³Ð«ØKPI 948 58.4.2 ¦bPowerPivot¤¤³Ð«Ø ¼h¦¸µ²ºc 950 58.4.3 ¦bPowerPivot¤¤ ³Ð«Ø³zµø¹Ï 953 58.5 §âBI»y¸q¼Ò«¬³¡¸p¨ì SharePoint¤W 955 58.6 ¦bSharePoint 2010¤¤ ºÞ²zPowerPivot¤u§@ï ¼Æ¾Úªº¦Û°Ê¨ê·s 955 58.7 ¨Ï¥ÎSQL Server Data Tools ³Ð«ØBI»y¸q¼Ò«¬ 956 58.8 ¥ÎSQL Server Data Tools ÂX®iBI»y¸q¼Ò«¬ 957 58.9 §âBI»y¸q¼Ò«¬³¡¸p¨ì Analysis Services¹ê¨Ò¤W 959 58.9.1 ³¡¸p¿ï¶µ 959 58.9.2 ³¡¸pªA°È¾¹¿ï¶µ 960 58.9.3 DirectQuery¿ï¶µ 960 58.10 ¤pµ² 960 ²Ä59³¹ ³Ð«Ø©M³¡¸pPower View ³øªí 961 59.1 Power Viewªºn¨D 961 59.1.1 ªA°È¾¹ºÝªºn¨D 961 59.1.2 «È¤áºÝªºn¨D 961 59.2 ¥ÎPower View³Ð«Ø©M ³¡¸p³øªí 962 59.2.1 ³Ð«Ø³s±µ¤å¥ó®w 963 59.2.2 ³Ð«ØReport Data Source ¤å¥ó 963 59.2.3 ³Ð«ØBI Semantic Model Connection¤å¥ó 965 59.2.4 ¥ÎPower View³Ð«Ø³øªí 966 59.3 ³¡¸pPower View³øªí 973 59.4 ¤pµ² 974
|
§Ç¡G |