{"id":205,"date":"2011-04-29T10:41:45","date_gmt":"2011-04-29T02:41:45","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=205"},"modified":"2013-12-30T14:00:59","modified_gmt":"2013-12-30T06:00:59","slug":"%e5%88%9b%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%ba%93%e5%bf%ab%e7%85%a7","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=205","title":{"rendered":"\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167"},"content":{"rendered":"<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4efb\u4f55\u80fd\u521b\u5efa\u6570\u636e\u5e93\u7684\u7528\u6237\u90fd\u53ef\u4ee5\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u91cd\u8981\u63d0\u793a<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u53ea\u6709<\/span><span lang=\"en-US\">\u00a0SQL Server 2005,SQL Server 2008\u00a0<\/span><span lang=\"zh-CN\">\u548c<\/span><span lang=\"en-US\">\u00a0SQL Server 2008 R2\u00a0<\/span><span lang=\"zh-CN\">\u7684<\/span><span lang=\"en-US\">\u00a0Enterprise Edition<\/span><span lang=\"zh-CN\">\u63d0\u4f9b\u4e86<\/span><span lang=\"en-US\">\u00a0SQL Server 2005\u00a0<\/span><span lang=\"zh-CN\">\u4e2d\u5f15\u5165\u7684\u6570\u636e\u5e93\u5feb\u7167\u529f\u80fd<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u7684\u6700\u4f73\u65b9\u6cd5<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4e0b\u9762\u662f\u8fdb\u884c\u5982\u4e0b\u64cd\u4f5c\u7684\u4e00\u4e9b\u6700\u4f73\u65b9\u6cd5<\/span><span lang=\"en-US\">:<\/span><span lang=\"zh-CN\">\u547d\u540d\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u521b\u5efa\u5b83\u4eec\u65f6\u8fdb\u884c\u8ba1\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u9650\u5236\u5b83\u4eec\u7684\u6570\u91cf\u4ee5\u53ca\u5c06\u5ba2\u6237\u7aef\u8fde\u63a5\u91cd\u65b0\u5b9a\u5411\u5230\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u547d\u540d\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u4e4b\u524d<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8003\u8651\u5982\u4f55\u547d\u540d\u5b83\u4eec\u662f\u975e\u5e38\u91cd\u8981\u7684<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6bcf\u4e2a\u6570\u636e\u5e93\u5feb\u7167\u90fd\u9700\u8981\u4e00\u4e2a\u552f\u4e00\u7684\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4e3a\u4e86\u4fbf\u4e8e\u7ba1\u7406<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5feb\u7167\u7684\u540d\u79f0\u53ef\u4ee5\u5305\u542b\u6807\u8bc6\u6570\u636e\u5e93\u7684\u4fe1\u606f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4f8b\u5982<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<ul style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6e90\u6570\u636e\u5e93\u7684\u540d\u79f0<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u8be5\u65b0\u540d\u79f0\u7528\u4e8e\u5feb\u7167\u7684\u6307\u793a\u4fe1\u606f<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<ul style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5feb\u7167\u7684\u521b\u5efa\u65e5\u671f\u548c\u65f6\u95f4<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e8f\u5217\u53f7\u6216\u4e00\u4e9b\u5176\u4ed6\u7684\u4fe1\u606f<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u4f8b\u5982\u4e00\u5929\u4e2d\u7684\u67d0\u4e2a\u65f6\u95f4<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u4ee5\u533a\u5206\u7ed9\u5b9a\u7684\u6570\u636e\u5e93\u4e0a\u7684\u8fde\u7eed\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4f8b\u5982<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8003\u8651<\/span><span lang=\"en-US\">\u00a0AdventureWorks2008R2\u00a0<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u7684\u4e00\u7cfb\u5217\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5728\u4e0a\u5348<\/span><span lang=\"en-US\">\u00a06\u00a0<\/span><span lang=\"zh-CN\">\u65f6\u548c\u4e0b\u5348<\/span><span lang=\"en-US\">\u00a06\u00a0<\/span><span lang=\"zh-CN\">\u65f6<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u57fa\u4e8e<\/span><span lang=\"en-US\">\u00a024\u00a0<\/span><span lang=\"zh-CN\">\u5c0f\u65f6\u5236<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u4e4b\u95f4<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4ee5<\/span><span lang=\"en-US\">\u00a06<\/span><span lang=\"zh-CN\">\u4e2a\u5c0f\u65f6\u4f5c\u4e3a\u95f4\u9694\u521b\u5efa\u4e09\u4e2a\u6bcf\u65e5\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6bcf\u4e2a\u6bcf\u65e5\u5feb\u7167\u4fdd\u6301<\/span><span lang=\"en-US\">\u00a024\u00a0<\/span><span lang=\"zh-CN\">\u5c0f\u65f6\u624d\u88ab\u5220\u9664\u5e76\u88ab\u540c\u4e00\u540d\u79f0\u7684\u65b0\u5feb\u7167\u66ff\u6362<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u8bf7\u6ce8\u610f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6bcf\u4e2a\u5feb\u7167\u540d\u79f0\u6307\u660e\u4e86\u5c0f\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u800c\u975e\u5929<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_0600<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_1200<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_1800<\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u53e6\u5916<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u8fd9\u4e9b\u6bcf\u65e5\u5feb\u7167\u521b\u5efa\u7684\u65f6\u95f4\u6bcf\u5929\u90fd\u53d8\u5316<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u63a8\u8350\u4f7f\u7528\u4e0d\u592a\u7cbe\u786e\u7684\u547d\u540d\u7ea6\u5b9a<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4f8b\u5982<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_morning<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_noon<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AdventureWorks2008R2_snapshot_evening<\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u9650\u5236\u6570\u636e\u5e93\u5feb\u7167\u7684\u6570\u91cf<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u968f\u7740\u65f6\u95f4\u7684\u53d8\u5316\u521b\u5efa\u4e00\u7cfb\u5217\u5feb\u7167\u53ef\u6355\u83b7\u6e90\u6570\u636e\u5e93\u7684\u8fde\u7eed\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6bcf\u4e2a\u6570\u636e\u5e93\u5feb\u7167\u4f1a\u4e00\u76f4\u5b58\u5728\u76f4\u5230\u663e\u5f0f\u5220\u9664<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u56e0\u4e3a\u6bcf\u4e2a\u5feb\u7167\u4f1a\u968f\u7740\u539f\u59cb\u9875\u7684\u66f4\u65b0\u800c\u4e0d\u65ad\u589e\u957f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6240\u4ee5\u60a8\u53ef\u80fd\u60f3\u5728\u521b\u5efa\u65b0\u5feb\u7167\u540e\u901a\u8fc7\u5220\u9664\u65e7\u7684\u5feb\u7167\u6765\u8282\u7701\u7a7a\u95f4<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u5982\u679c\u60f3\u8981\u8fd8\u539f\u5230\u67d0\u4e2a\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u9700\u8981\u4ece\u8be5\u6570\u636e\u5e93\u4e2d\u5220\u9664\u6240\u6709\u5176\u4ed6\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u5ba2\u6237\u7aef\u8fde\u63a5\u5230\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u82e5\u8981\u4f7f\u7528\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5ba2\u6237\u7aef\u9700\u8981\u77e5\u9053\u5b83\u7684\u4f4d\u7f6e<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6b63\u5728\u521b\u5efa\u6216\u5220\u9664\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u5feb\u7167\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7528\u6237\u53ef\u4ee5\u4ece\u4e00\u4e2a\u6570\u636e\u5e93\u5feb\u7167\u8bfb\u53d6<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u662f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u7528\u65b0\u5feb\u7167\u66ff\u4ee3\u73b0\u6709\u5feb\u7167<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u60a8\u9700\u8981\u5c06\u5ba2\u6237\u7aef\u91cd\u65b0\u5b9a\u5411\u5230\u65b0\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u7528\u6237\u53ef\u4ee5\u901a\u8fc7<\/span><span lang=\"en-US\">\u00a0SQL Server Management Studio\u00a0<\/span><span lang=\"zh-CN\">\u624b\u52a8\u8fde\u63a5\u5230\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u662f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u82e5\u8981\u652f\u6301\u751f\u4ea7\u73af\u5883<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u60a8\u5e94\u8be5\u521b\u5efa\u4e00\u4e2a\u7f16\u7a0b\u89e3\u51b3\u65b9\u6848<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8be5\u65b9\u6848\u900f\u660e\u5730\u5c06\u62a5\u8868\u7f16\u5199\u5ba2\u6237\u7aef\u5b9a\u5411\u5230\u6570\u636e\u5e93\u7684\u6700\u65b0\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"en-US\">SQL Server Management Studio\u00a0<\/span><span lang=\"zh-CN\">\u4e0d\u652f\u6301\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u7684\u552f\u4e00\u65b9\u5f0f\u662f\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0Transact-SQL.<\/span><span lang=\"zh-CN\">\u53ef\u521b\u5efa\u6570\u636e\u5e93\u7684\u4efb\u4f55\u7528\u6237\u90fd\u53ef\u4ee5\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">;<\/span><span lang=\"zh-CN\">\u4f46\u662f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u82e5\u8981\u521b\u5efa\u955c\u50cf\u6570\u636e\u5e93\u7684\u5feb\u7167<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u60a8\u5fc5\u987b\u662f<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">sysadmin<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u56fa\u5b9a\u670d\u52a1\u5668\u89d2\u8272\u7684\u6210\u5458<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<ol style=\"color: #333333; font-size: 10.5pt; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; font-family: Calibri; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"1\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-style: normal;\">\u6839\u636e\u6e90\u6570\u636e\u5e93\u7684\u5f53\u524d\u5927\u5c0f<\/span><span lang=\"en-US\" style=\"font-style: normal;\">,<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u786e\u4fdd\u6709\u8db3\u591f\u7684\u78c1\u76d8\u7a7a\u95f4\u5b58\u653e\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u6570\u636e\u5e93\u5feb\u7167\u7684\u6700\u5927\u5927\u5c0f\u4e3a\u521b\u5efa\u5feb\u7167\u65f6\u6e90\u6570\u636e\u5e93\u7684\u5927\u5c0f<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><\/span><\/span><\/li>\n<\/ol>\n<ol style=\"color: #333333; font-size: 10.5pt; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; font-family: Calibri; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"1\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-style: normal;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"font-style: normal;\">\u00a0AS SNAPSHOT OF\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u5b50\u53e5\u5bf9\u6587\u4ef6\u6267\u884c<\/span><span lang=\"en-US\" style=\"font-style: normal;\">\u00a0CREATE DATABASE\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u8bed\u53e5<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u521b\u5efa\u5feb\u7167\u9700\u8981\u6307\u5b9a\u6e90\u6570\u636e\u5e93\u7684\u6bcf\u4e2a\u6570\u636e\u5e93\u6587\u4ef6\u7684\u903b\u8f91\u540d\u79f0<\/span><\/span><\/span><\/li>\n<\/ol>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u65f6<\/span><span lang=\"en-US\">,CREATE DATABASE\u00a0<\/span><span lang=\"zh-CN\">\u8bed\u53e5\u4e2d\u4e0d\u5141\u8bb8\u6709\u65e5\u5fd7\u6587\u4ef6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8131\u673a\u6587\u4ef6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8fd8\u539f\u6587\u4ef6\u548c\u4e0d\u8d77\u4f5c\u7528\u7684\u6587\u4ef6<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"font-weight: bold;\">A.\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5bf9<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">\u00a0AdventureWorks2008R2\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6570\u636e\u5e93\u521b\u5efa\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6b64\u793a\u4f8b\u5bf9<\/span><span lang=\"en-US\">\u00a0AdventureWorks2008R2\u00a0<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5feb\u7167\u540d\u79f0<\/span><span lang=\"en-US\">\u00a0AdventureWorks2008R2_dbss_1800\u00a0<\/span><span lang=\"zh-CN\">\u53ca\u5176\u7a00\u758f\u6587\u4ef6\u7684\u540d\u79f0<\/span><span lang=\"en-US\">\u00a0AdventureWorks2008R2_data_1800.ss\u00a0<\/span><span lang=\"zh-CN\">\u6307\u660e\u4e86\u521b\u5efa\u65f6\u95f4<\/span><span lang=\"en-US\">\u00a06 P.M.(1800\u00a0<\/span><span lang=\"zh-CN\">\u5c0f\u65f6<\/span><span lang=\"en-US\">).<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">CREATE DATABASE AdventureWorks2008R2_dbss1800 ON<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = AdventureWorks2008R2_Data, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/Data\/AdventureWorks2008R2_data_1800.ss&#8217; )<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AS SNAPSHOT OF AdventureWorks2008R2;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">GO<\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u793a\u4f8b\u4e2d\u968f\u610f\u4f7f\u7528\u4e86\u6269\u5c55\u540d<\/span><span lang=\"en-US\">\u00a0.ss.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"font-weight: bold;\">B.\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5bf9<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">\u00a0Sales\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6570\u636e\u5e93\u521b\u5efa\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6b64\u793a\u4f8b\u5bf9<\/span><span lang=\"en-US\">\u00a0Sales\u00a0<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">\u00a0sales_snapshot1200.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8211;Creating sales_snapshot1200 as snapshot of the<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8211;Sales database:<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">CREATE DATABASE sales_snapshot1200 ON<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SPri1_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SPri1dat_1200.ss&#8217;),<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SPri2_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SPri2dt_1200.ss&#8217;),<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SGrp1Fi1_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SG1Fi1dt_1200.ss&#8217;),<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SGrp1Fi2_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SG1Fi2dt_1200.ss&#8217;),<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SGrp2Fi1_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SG2Fi1dt_1200.ss&#8217;),<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">( NAME = SGrp2Fi2_dat, FILENAME =<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8216;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.MSSQLSERVER\/MSSQL\/data\/SG2Fi2dt_1200.ss&#8217;)<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">AS SNAPSHOT OF Sales<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">GO<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4efb\u4f55\u80fd\u521b\u5efa\u6570\u636e\u5e93\u7684\u7528\u6237\u90fd\u53ef\u4ee5\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167. \u91cd\u8981\u63d0\u793a:\u53ea\u6709\u00a0SQL Server 2005,SQL Serv [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-sql_server_2008_r2"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}