{"id":29,"date":"2013-12-27T17:01:56","date_gmt":"2013-12-27T09:01:56","guid":{"rendered":"http:\/\/www.royalwzy.com\/?page_id=29"},"modified":"2015-06-05T17:20:56","modified_gmt":"2015-06-05T09:20:56","slug":"mssql","status":"publish","type":"page","link":"http:\/\/www.royalwzy.com\/?page_id=29","title":{"rendered":"MSSQL"},"content":{"rendered":"

\u5168\u6587\u7d22\u5f15<\/a>
\nCreate Index\u8bed\u53e5\u7684Include\u4f5c\u7528<\/a>
\nStop Words<\/a>
\n\u586b\u5145\u56e0\u5b50<\/a>
\nSQL Server 2008 \u66f4\u6539\u8ddf\u8e2a<\/a>
\nSQL Server 2008 \u53c2\u6570\u5316\u67e5\u8be2<\/a>
\n\u5982\u4f55\u6536\u7f29\u6570\u636e\u5e93\u65e5\u5fd7\u6587\u4ef6<\/a>
\nsqlservr \u5e94\u7528\u7a0b\u5e8f(\u8f6c)<\/a>
\nDBCC \u8bed\u53e5\u603b\u7ed3<\/a>
\n\u5982\u4f55\u8bbf\u95ee\u5176\u5b83\u670d\u52a1\u5668\u4e0a\u7684\u6570\u636e\u5e93<\/a>
\n\u5206\u79bb\u548c\u9644\u52a0\u6570\u636e\u5e93\u6587\u4ef6<\/a>
\nSqlServer\u4e2d\u65e5\u671f\u548c\u65f6\u95f4\u6570\u636e\u7c7b\u578b\u53ca\u51fd\u6570<\/a>
\nCommon Table Expression (CTE)<\/a>
\nSCOPE_IDENTITY \u51fd\u6570\u4f7f\u7528<\/a>
\n\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\u65f6\u7684WITH RECOMPILE \u9009\u9879<\/a>
\nSPARSE\u5217\u7684\u4f7f\u7528<\/a>
\n\u4f7f\u7528TOP\u9650\u5236\u5220\u9664\u7684\u884c<\/a>
\nXML\u6587\u4ef6\u5bfc\u5165SQL Server<\/a>
\n\u6e05\u7a7a\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u6570\u636e\u7684\u65b9\u6cd5<\/a>
\n\u5982\u4f55\u66f4\u6539\u5bf9\u8c61\u6240\u5c5e\u7684\u67b6\u6784<\/a><\/p>\n

SqlServer\u6570\u636e\u5e93\u8bbf\u95eeOracle\u6570\u636e\u5e93<\/a>
\nSQLServer2008\u963b\u6b62\u4fdd\u5b58\u8981\u6c42\u91cd\u65b0\u521b\u5efa\u8868\u7684\u66f4\u6539<\/a>
\nUPDATE SET FROM \u8bed\u53e5<\/a>
\nDatabase Mirroring<\/a>
\n\u5982\u4f55\u4fdd\u5b58\u6570\u636e\u5e93\u7ea7\u522b\u4fee\u6539\u7684\u8bb0\u5f55<\/a>
\n\u9632\u6b62\u8868\u88ab\u5220\u9664\u7684\u89e6\u53d1\u5668<\/a><\/p>\n

\u5355\u72ec\u8fd8\u539f\u4e2a\u522b\u6587\u4ef6\u64cd\u4f5c<\/a>
\nmaster\u6570\u636e\u5e93\u7684\u5907\u4efd\u4e0e\u6062\u590d<\/a>
\n\u5c3e\u65e5\u5fd7\u5907\u4efd<\/a>
\n\u9875\u9762\u8fd8\u539f<\/a><\/p>\n

\u6570\u636e\u5e93\u5feb\u7167\u7b80\u4ecb<\/a>
\n\u6570\u636e\u5e93\u5feb\u7167\u7684\u5de5\u4f5c\u65b9\u5f0f<\/a>
\n\u6570\u636e\u5e93\u5feb\u7167\u7684\u5178\u578b\u7528\u6cd5<\/a>
\n\u6570\u636e\u5e93\u5feb\u7167\u7684\u9650\u5236\u548c\u8981\u6c42<\/a>
\n\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167<\/a>
\n\u6570\u636e\u5e93\u5feb\u7167\u4e2d\u7684\u7a00\u758f\u6587\u4ef6\u5927\u5c0f<\/a>
\n\u6062\u590d\u5230\u6570\u636e\u5e93\u5feb\u7167<\/a>
\n\u5220\u9664\u6570\u636e\u5e93\u5feb\u7167<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u5168\u6587\u7d22\u5f15 Create Index\u8bed\u53e5\u7684Include\u4f5c\u7528 Stop Words \u586b\u5145\u56e0\u5b50 SQL Serve […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":30,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-29","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"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=29"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/29\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}