《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记二:Dimensions
SQL Server 2008中SQL应用系列及BI笔记系列--目录索引导读:在上文本创建SQL Server Analysis Service项目的基础上,继续介绍创建标准维度(Dimensions)和时间维度、父子维度的基本过程。
本文末尾提供两个项目源码:AdventureWorks_BI_Begin和AdventureWorks_BI_End,顾名思义,开始和完成。另外,包括数据库文件SSAS2008SBS_Data,请读者自行修改数据源ds的连接串。
Tips:设计维度前最重要的一个步骤是透彻了解源数据。
http://laodtw.bay.livefilestore.com/y1p3Bl9KPnPNAIgk653-JCZFwEpe455QIhg630PPaUT2cApxKAEB6oy-61kYO92PgIhy7NOFmcvD5BC9Af8BcpQKHM42j_8mZBU/2011-4-17%208-43-24.png?psid=1
打开项目,并在dsv文件,右键“View Designer”,在视图设计界面,选择“First Dimensions”图表。
http://laodtw.bay.livefilestore.com/y1p3Bl9KPnPNAJxGYu0y18WArasrprM0AtMcH-qwJujOyqNRILnhnod26cHs-hWMFVMel3RJPKMrU-cf2yf_hLyQNf_GNLvpQ_M/2011-4-17%2010-23-33.png?psid=1
其中,product维度是一个雪花型(snowfake)维度。DimProduct表通过外键与DimProductSubcategory表关联,后者又通过外键与DimProductCategory表关联。
DimDate是一个标准维度表,但为了数据能被装载到Analysis services而创建了一些计算成员。
DimEmployee表的ParentEmployeeKey列与EmployeeKey列有一个外键关联。这是一个自关联,因而Employee维度是一个父子维度(parent-child demensions)。
我们先熟悉一下源数据:
http://laodtw.bay.livefilestore.com/y1pkkHVbTQRh_OblndNI8TRa9eWwIJtmLjCMJo8JFrvRcmSODU9PH-pI-lxojuB5u91UtNl5J903KpAKEUf6c9ZJvuYfK-5YEm1/2011-4-17%2011-06-30.png?psid=1
http://laodtw.bay.livefilestore.com/y1pkkHVbTQRh_MC32-XXTArGO2W_kxzlh_4N4Ec9REdKkjF0OFyuf7XAjvHoXOuAzEoVZY87X-CVDTP0M0d0OLni9HuuLnHmXgw/2011-4-17%2011-09-53.png?psid=1
http://laodtw.bay.livefilestore.com/y1p5qnoZxzbxOwb2ta7WxH3xPn6JqKOqQHzIx_KZ2KN3tVICkE61-Nf9RGkxBHq8L5vOlBLvCSCwe5SpmsrIiFFTZKhGGFIRC5M/2011-4-17%2011-13-08.png?psid=1
http://laodtw.bay.livefilestore.com/y1pBMgViKj4KV29nEdmUPJ2Sv4c_0g2O6aPF3dse7uXv9e1TNNl7gndtm5kQAXjR752eYwRMboNPEh6pJ5aCvIos0t5y9oVPvwo/2011-4-17%2011-20-06.png?psid=1
(一)创建标准维度
Tips:你必须通过向导来初始化一个维度。在此过程中你将选择源表,键及其他属性。然而,在初始化完成后,多数情况下,你可能需要通过Dimension Designer。
在项目的Dimensions目录,右键“New Dimension”
http://laodtw.bay.livefilestore.com/y1p7smK-opgKOa5HZQHuTil3F33Gb_j_dCjumUsGagQSeRyN6qa5VOFO3zXk6s7etX1qVGhc7w_MvBS2P4_K4uh-RpwGg8b6U7L/2011-4-17%2012-05-25.png?psid=1
http://laodtw.bay.livefilestore.com/y1p7smK-opgKOaR6Kxrip-LI1FNRfKEjW4DSGF2JIDEpZkBmaotvLhmVjLRZV22uaRuowRsxbGyeuZkVjbk1Hbqnr2BuYL4EKdi/2011-4-17%2012-15-48.png?psid=1
http://laodtw.bay.livefilestore.com/y1pORtdvzcak7o25rMTnzryalEXZZr59xRznUCjKiAMqLvahgCUKZNJCsCpEoWVJHM4GSgGU_u-I4b29wX7ZdDAJe7Mm_s0Ubh4/2011-4-17%2012-27-11.png?psid=1
http://laodtw.bay.livefilestore.com/y1pm0vMYeBaFlaJsexBEJ9NhkPZ0191y8Gya6OcdheVpfFVcVb1F2RjKYQzTzhSSteTLMHn-UG3Vj40IuJEc8TOxUOzuyAfQYBD/2011-4-17%2012-28-51.png?psid=1
http://laodtw.bay.livefilestore.com/y1pl2HN0HWIQ_uvMNGIKTKqEUcBOF8Ag9GgEzhAhrFcbITzt5N2mkT4n80CQX0ru8Tw3IFMDLKVB3xTchqE0u74kydsiqhXQrMb/2011-4-17%2012-33-21.png?psid=1
http://public.bay.livefilestore.com/y1piO3e_Xh_mGrJTZpAsM-9wqYujQL8XNHWFl6Sdz550e7vhh11zRE6SFvrwZrJNotIwP5ifyN_2xUZVfUxPVlQ5w/2011-4-17%2012-38-55.png?psid=1
http://public.bay.livefilestore.com/y1pH-Soszq0alsiY-YtiP6DE6i3Kr2HpvCJY0GdfzAbWaw1FtFnTT7iaAtpNV0GCJn-4ucTr8pHiJnnCIIeNU7qWw/2011-4-17%2012-45-21.png?psid=1
http://public.bay.livefilestore.com/y1pqsiu-XHgEc-r6AmbVNO1X5TZdst5T4sBXnMK0jF7WfhnN51JMOKJyNMzRPt2NUZYeUD8QuOsIL7KmTCFE_AUKQ/2011-4-17%2012-51-13.png?psid=1
我们此时需要部署一个Analysis Services数据,步骤如下:
http://public.bay.livefilestore.com/y1poX6Epf_aqJPxhZZgA7BDscuHZs8eaIOGfzm6_fYzGyOpX5Na4wyUj_kxvXb9NPvklj6rMsRDxppVzZSL--3FHg/2011-4-17%2013-28-53.png?psid=1
如果收到错误信息:
The project could not be deployed to the 'localhost' server because of the following connectivity problems :A connection cannot be made. Ensure that the server is running.To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
请启动SQL server Analysis Service服务,并设置项目属性中的Deployment中的Server属性为实际的SQL Server实例名。
http://public.bay.livefilestore.com/y1pW-xFT50aIb9YApzmkHbD9bGtKzmUMpBwFTA9oNtnVnXN4cQ2IAwyFlD885e6JhsCu_WEUsm9u5csUPOhhWsbrQ/2011-4-17%2012-58-34.png?psid=1
http://public.bay.livefilestore.com/y1pAj4OyKnp9Gc6eEQcWsYeQ76E4NYmRUbPd1pxrKjM97721XJ3S4KF7r3DaPw75TD-bVD09j98d_NvLaCmnNaPXg/2011-4-17%2013-30-36.png?psid=1
http://public.bay.livefilestore.com/y1pFKw3lewAOBVzszU2FCRYX5cxTMxMuG5kXnf6JAoptbmD18l17inJVAS2d7x4phxoa5S0aRYj6xpT6d2Pibg5mQ/2011-4-17%2013-34-59.png?psid=1
http://public.bay.livefilestore.com/y1pFKw3lewAOBVp7ldvObEcD0m1mF49wQI-Rz_JwCZ-Rr8sFj_L_b4aJABae_uzrt0APnqbKwFr28SzBWGXvtbQtQ/2011-4-17%2013-32-36.png?psid=1
http://public.bay.livefilestore.com/y1pFKw3lewAOBVF27MbkSiTbq6iLNnbuviHphiBwwamuoB9pN5c3-Lx19SF1lXjD56pVK0aYOn9UZUr0M701fVJNQ/2011-4-17%2013-38-07.png?psid=1
http://public.bay.livefilestore.com/y1psdwfuuvNDvfBem6pcDeek06aFiFDw1nOFpbtX4LZE2PBXe30NAoYSm8gsBr6ZYqcHFD13pSVPT-tsw-z_iGXbg/2011-4-17%2013-40-02.png?psid=1
(二)修改维度
维度创建完成后,需要修改,步骤如下:
选择“product”维度,右键,“View Designer”
http://public.bay.livefilestore.com/y1pRDDP0s_8s6Bx3SzX9BBwdfGvFtLcz2X0q6YlXhVrxzGVwsuiSsIE-67QUe3vJV6em9tLHFbhEKuiPFc_Jg08HA/2011-4-17%2013-45-56.png?psid=1
http://public.bay.livefilestore.com/y1paXxY1Xp-tS0zE5uoqZeRMB8lKcSB68dxHgpH0WQyq8jDAp1I6SCr11CMsdK84xkvIykwvgAHZpboA0HGhwKIqQ/2011-4-17%2013-48-38.png?psid=1
http://public.bay.livefilestore.com/y1p45iw1GPC2XFBOh07IV1pCujmCaxQktxI5LKjk0Vk1WF75Ack0HthQcwn3JNmIT7K2GKEU6hLI2r8R77tATY62g/2011-4-17%2013-50-45.png?psid=1
http://public.bay.livefilestore.com/y1puQC-QNg_hjr052D-1Xz-9YD-AmxFJfRW48bMAbRuFX4J1T5mBcYwu56mdBKEIxJ8ig7zarIdkJD46r8NEV7ELg/2011-4-17%2014-03-41.png?psid=1
在友好智能提示的再三劝诫下,我们还是从了她的心愿吧!
http://public.bay.livefilestore.com/y1pCst6tUpbp71JkguLxxlWJs6BakFEh0gC_RY6nfMeOnlBIfF41GsHG_bbZPP0o95h0ec6D0YlrBQ8R9XJKlCuKw/2011-4-17%2013-55-48.png?psid=1
http://public.bay.livefilestore.com/y1pCst6tUpbp73GzZ7ruSlqWG9ikrcG6ctqIZDWEblQYM1vF_GjzyMCR3d50PTMMd7-TvGHUgdbWwDIwfvLIyqG-w/2011-4-17%2013-58-27.png?psid=1
http://public.bay.livefilestore.com/y1pf7s1-uvhpcEMnkl0vdC8er2ZysB3GaBY3N4F3muupekrNPiLJQ9vQTHrpRE5eTPi4v2u6Tzz61PWny-rHYn0ew/2011-4-17%2014-10-11.png?psid=1
注意:你可以隐藏一个属性层次,但实际上,它还是存在的,意识到这点的用户可以写MDX查询和恢复(retrieve)层次成员。
隐藏步骤如下:
http://public.bay.livefilestore.com/y1p8oyIZJv-PIYScWr7XPKT4fE370nVpJkZo8r16mmg5o5qS9Kw3cJJZdKibkgmd-P9SB_vkUi8-Wb4lvmfdUBZCw/2011-4-17%2014-18-21.png?psid=1
对Category和Product和Subcategory分别设置不可见。
重新部署项目,并Reconnection。
http://public.bay.livefilestore.com/y1p8oyIZJv-PIbJkLHXXKq-NO3wIUGcMyQsuFgwBQVoF1G135Ov4dK-cM_l3oh9rmeaRy0eHgaV_i3tyFDT2e-4WQ/2011-4-17%2014-24-26.png?psid=1
http://public.bay.livefilestore.com/y1p8oyIZJv-PIbJirDT5MAbSYN9HSV9aDmLkngNde8MEmdgw7xsNb-quGzFIVs3VwD3SlCk3KZGzg5MRWdFv3iXTQ/2011-4-17%2014-26-06.png?psid=1
http://public.bay.livefilestore.com/y1pCPRhoZ0tjYQ1wMOQ_i4XlhwsboAAZnJXnJt3vBwFqYEa883OVF2Uo4SJg9mwPkMVnP9I5KPA2ybZ5jYpD4SDGw/2011-4-17%2014-42-14.png?psid=1
http://public.bay.livefilestore.com/y1p8lg1t-YulQgukKavku3lRq77fFrQDeHZvPS5WRbO-l5AhgXKgCFS5vaNs-yAW5427PhtaAQ2vXXebEjfK6K0KA/2011-4-17%2014-45-48.png?psid=1
http://public.bay.livefilestore.com/y1p8lg1t-YulQgv19UtCZ7KvtWo3GWZDeObxaHgshCgjvvMLpTQ9le_6nxmIP0t5L6QCjr5TthM31y5TXDoaaXUZA/2011-4-17%2014-49-49.png?psid=1http://public.bay.livefilestore.com/y1padzbt5mT8Ar0N7kD8RJVZ7gMlPzQF32QHm1P63oDPBwGHcYtYTXZDq68_4DTa_tsJfMVYWaSXpQ10QVWsQ25Hg/2011-4-17%2015-01-27.png?psid=1
http://public.bay.livefilestore.com/y1pahoBMRBorK-sR5gVIRr665HlN6AM2QToXdmsUuVGjA2X1kTIgJ29Wq03UzZy4fX8eS8y7y81vU3kKnaOCUTBEQ/2011-4-17%2015-04-49.png?psid=1
http://public.bay.livefilestore.com/y1pmZD8mnp_2MGUFO1Cv-uxe4KSX-ofe5e4vXdFDhNXCq6jxVUTkFGTiltLNeFQ8igrdszMuDfQ7HlNGzLniTfw5g/2011-4-17%2015-07-30.png?psid=1
(三)创建时间维度
有了前面的基础,再新建一个时间维度就比较容易了。
http://public.bay.livefilestore.com/y1pmZD8mnp_2MFAUusN6ImJJ6feqUduRMZZGq11oHl5zMhZeReCJ5I3A0fRM6AYih2JL7QShBG8pJFVa2JuOvSvRQ/2011-4-17%2015-16-06.png?psid=1
http://public.bay.livefilestore.com/y1pIrIIOqKw66aOBIu5pkZmS4WxXS0sKWTvg-h_vsrP-pDi5BfQ8T1q7K2tx_uaJBb1rQ-WQK14JrduPyD1QnUp2A/2011-4-17%2015-13-33.png?psid=1
修改这些属性:
http://public.bay.livefilestore.com/y1pT1PIlMGBgGYbfKSHDs56B_RgQbJtzxYk_qpIAUy8Q8P3CeeVcSGgWbpEBM5bWARkK28YrYOaf_ujM_Vx12zTZA/2011-4-17%2015-18-22.png?psid=1
http://public.bay.livefilestore.com/y1p0beaavICu4wLdktE5q_k_pKbNR15UsQ7ex2QsuGknee64BPrTWfJT5u7LFJkJYIpgkQTJqzVNhtHL1mJwJcD1Q/2011-4-17%2015-24-33.png?psid=1
http://public.bay.livefilestore.com/y1pmexroGLHBc_rk4V2GJyhWkTP_ox1hkvxWxsOOH4K2atO8UccAwQAFCWFts0ikUE4YsBxXTRJXrgTmVZUmZcMbA/2011-4-17%2015-25-18.png?psid=1
注意:创建完成后,我们再来调整属性。
http://public.bay.livefilestore.com/y1pnAO8_LcQgu_zUHY4U7DljZqRXKPrNvcdLcDOlFmhy1jr-SbMrtUu8McC2y9Wzp9NtkjENYufuGsPx5xst-QpRQ/2011-4-17%2015-27-35.png?psid=1
按照上图,修改如下属性的 NameColumn值:
http://public.bay.livefilestore.com/y1pnAO8_LcQgu-BhrgUEQ2xPyXxvv2A_WXL3kS4_ZyjmH-ui8RXsQzlfbYmEr0dIriSpgUmJOGzaW_Ok1Z37s_nDQ/2011-4-17%2015-30-17.png?psid=1
http://public.bay.livefilestore.com/y1pqchT8ZJS0nXz1ib2JvuI7T3kotQnoc429AOd72YV2GiXo0cFrgU2DNDBBwNPHmkWsB4rHf726-EPqXy-0v9AFw/2011-4-17%2015-43-37.png?psid=1
修改属性关联:
http://public.bay.livefilestore.com/y1pREUJzrWoVZAo3P-Cdma0AGz-v52njQc3VVoGdyR1E1z1cQqPyluVNcM004BZrTCdOYvKHtnyiwuqaANjn-AL8A/2011-4-17%2015-45-41.png?psid=1
http://public.bay.livefilestore.com/y1pREUJzrWoVZCOOtraR0mA8tf5fBF2ivfwt6jlbqINaDk9SetoZ3HJ5H7dpTAWcw4TZeCOWAr14Yn9PzfI8fHEyQ/2011-4-17%2015-52-01.png?psid=1
部署项目,欣赏下我们的劳动成果!
http://public.bay.livefilestore.com/y1p7GRTgTwvCKo3xPNBV3XPBuN3UC6lNzkOd3VCF1vdq6MKLa3TxgRoaxmFrZK9P6T2md4YU82-0xVZN4sBZIDyAQ/2011-4-17%2015-56-20.png?psid=1
因为年有重复,我们修改Month Name列:
http://public.bay.livefilestore.com/y1p7GRTgTwvCKpl8h4n3r0tPFzzCbPsBP8N3Gbx5IKAp99wq7yLmQj3C9mYAeKtl7TSk0gzJLHizdldKIXL9JI4AA/2011-4-17%2016-00-29.png?psid=1
http://public.bay.livefilestore.com/y1p7GRTgTwvCKq836SxqgYUcvnp1mW3_tns5WlhiX5MHxxgkxmQWL6Bo-HrYCZ3XpWKbLb4avzR2cHuEL58JgfaaQ/2011-4-17%2016-01-42.png?psid=1
此时,去除年份,按月份的字母排列,而不是按月份从小到大排列,需要再次修正。步骤如下:
http://public.bay.livefilestore.com/y1peURj6xTUWrXNKPQZF8aF4cWjxVP7DRqCSUdxAsXTPxyvE2fQz7KkXmiy6_jwGIzovSnEtFDdHzgNzVixLe8oIA/2011-4-17%2016-09-26.png?psid=1
http://public.bay.livefilestore.com/y1peURj6xTUWrVZyzffZrh1r5Mo_4voZY0gz8l8IS4oT90INIBshkZ6h7wlSHOF3iqwnE0iO3fvgZn-i5UtUhPXfA/2011-4-17%2016-13-52.png?psid=1
http://public.bay.livefilestore.com/y1p1y7d085vVeQZVSso2JO4WnsgHjcrCmmqsNfGHxFuF13DaeuRkRH5_ZAkFBwlPF87XqCHKB7818IyJQyinQRtGw/2011-4-17%2016-16-30.png?psid=1
http://public.bay.livefilestore.com/y1pYu2Qab1iQaRm-nw9TpTrwumiTwluSJu4m78ZrJ1T78Y-mKA7cPoeDY8UqGMLx8KCcYZoc6grKpf5DMuhpbz2CQ/2011-4-17%2016-17-55.png?psid=1
(四)创建父子维度
父子关系(Parent-Child)是常见的一种关联关系。一种特殊的父子关系是自关联。假定一个Employee表的ParentEmployeeKey对应某个Employee的上司,而主键是EmployeeKey。当然,这只是一个简单模型,实际上一个Employee不会只属于一个上司。
http://public.bay.livefilestore.com/y1pYu2Qab1iQaTGGuigqtczmYqt-zgoYyu_l7j0vqWTkAjIbRLCOXIIKZw90mQYklloOOUVg44atxge0MzhU0ZrWA/2011-4-17%2016-31-02.png?psid=1
http://public.bay.livefilestore.com/y1pYQ2tqYe56ACEjqWPtcgIhnolV9XbD7IReEpc9QlQT1WiNQ5RZnnWxMDiLrmE5_-jVUntPSdCh2ND3nvAGaKajg/2011-4-17%2016-33-02.png?psid=1
http://public.bay.livefilestore.com/y1pJXgE6qngo63wmaEUX76D59TrKiKQi7Q2IOh9Q2mNq1Hj1w4MiEC8CMllwpM2IN7-asBBzGWed5eTJhhWEq_Yiw/2011-4-17%2016-37-12.png?psid=1
http://public.bay.livefilestore.com/y1p7CKGeKONh_JI2TGkTnHVtEr58AtevXYC97dD2dnbIaJoDALR2jYAGt0bW6UD-gD8yOQOeflK6POcfZ33zyp8Mw/2011-4-17%2016-41-24.png?psid=1
注意:系统自动设置如下属性:
http://public.bay.livefilestore.com/y1pJXgE6qngo62_Faec_k_PXDLxon5q9DjXm0kyrtkrzhb6Y4XD2bLj4MqlKHKe21tL6Gi-xSJdCv-lecW2jEysnQ/2011-4-17%2016-45-16.png?psid=1
http://public.bay.livefilestore.com/y1pUpnRdtH5Lsa7vq1cyE2Tk0WCMJL-fyKuBOdGDhoqXF4bte-KbWMmZJFhBUGwZKQDVxuFTh9jeHf7_FcaEmzJXQ/2011-4-17%2016-45-56.png?psid=1
修改排序,且排序字段不可见:
http://public.bay.livefilestore.com/y1pUpnRdtH5LsYMBAEzh1RSu5wKWi5o_x81XmAc1b6ES9oj3fv25ev4WTuysDhxhaTjX1xLQGxtd9eMJ5MjmnLWng/2011-4-17%2016-51-21.png?psid=1
http://public.bay.livefilestore.com/y1pHD6MMVls6HLcpAuSbo9cj9EJUN_T1FaQRgusDOJ5I_fo5IuSI669swzD_bIYtifREkwTe6_Ao4xDYaJSES9wEQ/2011-4-17%2016-52-19.png?psid=1
最后一个问题:如果统计重复,如下:
http://public.bay.livefilestore.com/y1pnKf84NU3wkoPxHcczH2ksyXNhbAznw7iH6o0qx7Edh6INKTHYSH_gwe1zEEYj9F8cs6RypE1pGLvBgz-5LhzJw/2011-4-17%2016-55-23.png?psid=1
处理办法:
http://public.bay.livefilestore.com/y1p0ASIMcKXJzlxwUvaI26TpJARmaRi08K9Li3wkVSHDwxvu_VymKnffuVkE_fAAqSBO4iGNGPFApGNP8kKZJZVrg/2011-4-17%2017-01-29.png?psid=1
效果如下:
http://public.bay.livefilestore.com/y1pNmKQdPmicAxj_xcQihh1viYmtWVq1s9nWU55MbgW0bmnQBsO7p4-_YWqezACSbt1pj-Ar6B9nCQNQk-gOSHKfA/2011-4-17%2017-02-18.png?psid=1
当然,也可以创建一个命名模板。
http://public.bay.livefilestore.com/y1pNmKQdPmicAzHm-V6AE5z85MNvYa_KPaVd8ryap0MqatsR-DKeEiunax8tkkdIboScqptxmE1MSI39dShbU0NeQ/2011-4-17%2017-09-41.png?psid=1
还有一个基本概念:
http://public.bay.livefilestore.com/y1pl2Gv-PRXATcPIywppV309kxvPW8Hx7v2VCgWveOlm8uLAzorXC41qO4pegislZYKxnThdPNMUYDcpnIR2QD2RA/2011-4-17%2017-12-24.png?psid=1
注意:属性设置“IsAggregatable”默认为true,意味着一个属性的单个成员也会被分组统计到一个All组,即有一个总上级,若改为False,将移去All。
http://public.bay.livefilestore.com/y1pGoW8h4Z7hHixsBPiKeoTMsa_caBvrr8Ph359GwhSZqa8x8HidvHjHoB8y7c7uxE-rnQcDpwPffK2CrRVmbCqBg/2011-4-17%2017-35-26.png?psid=1
而设置为False时。必须同时设置默认成员:
http://public.bay.livefilestore.com/y1pFupWivt2JLQglMyvWXsEIPZMKXC5MbMBCtKU8H12MLZEGA071o1Io3SklfcyZ6_2zCkG3qp7-VEmxyAh_Elbgw/2011-4-17%2017-17-49.png?psid=1
http://public.bay.livefilestore.com/y1psOtKCHUvOQa70tbyaIPT1r6yJr0WalVvu5UEDvQyHs_sKSA41bhesFVj6TT31rkfOwezg1GUfkQNtYft0CoiJA/2011-4-17%2017-50-44.png?psid=1
繁忙的学习结束了!感谢耐心看完!
小结:本文介绍了三种重要的维度创建方法:标准维度、时间维度和父子维度。相信大家手动作一遍,对维度会有一个比较初步的了解。请记住:在创建维度前先熟悉源数据表。下文将一起体验下Cube的创建过程。
附: SQL Server Analysis Services 官方教程(http://technet.microsoft.com/zh-cn/library/ms170208.aspx)
源码下载:
begin
end
数据库下载
页:
[1]