{"id":221,"date":"2011-02-05T10:48:27","date_gmt":"2011-02-05T02:48:27","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=221"},"modified":"2013-12-30T13:58:37","modified_gmt":"2013-12-30T05:58:37","slug":"sparse%e5%88%97%e7%9a%84%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=221","title":{"rendered":"SPARSE\u5217\u7684\u4f7f\u7528"},"content":{"rendered":"

\u7a00\u758f\u5217\u662f\u5bf9<\/span>\u00a0Null\u00a0<\/span>\u503c\u91c7\u7528\u4f18\u5316\u7684\u5b58\u50a8\u65b9\u5f0f\u7684\u666e\u901a\u5217<\/span>.<\/span>\u7a00\u758f\u5217\u51cf\u5c11\u4e86<\/span>\u00a0Null\u00a0<\/span>\u503c\u7684\u7a7a\u95f4\u9700\u6c42<\/span>,<\/span>\u4f46\u4ee3\u4ef7\u662f\u68c0\u7d22\u975e<\/span>\u00a0Null\u00a0<\/span>\u503c\u7684\u5f00\u9500\u589e\u52a0<\/span>.<\/span>\u5f53\u81f3\u5c11\u80fd\u591f\u8282\u7701<\/span>\u00a020%\u00a0<\/span>\u5230<\/span>\u00a040%\u00a0<\/span>\u7684\u7a7a\u95f4\u65f6<\/span>,<\/span>\u624d\u5e94\u8003\u8651\u4f7f\u7528\u7a00\u758f\u5217<\/span>.<\/span>\u7a00\u758f\u5217\u548c\u5217\u96c6\u662f\u901a\u8fc7\u4f7f\u7528<\/span>\u00a0CREATE TABLE\u00a0<\/span>\u6216<\/span>ALTER TABLE\u00a0<\/span>\u8bed\u53e5\u5b9a\u4e49\u7684<\/span>.<\/span><\/span><\/span><\/p>\n

\u7a00\u758f\u5217\u53ef\u4ee5\u4e0e\u5217\u96c6\u548c\u7b5b\u9009\u7d22\u5f15\u4e00\u8d77\u4f7f\u7528<\/span>\uff1a<\/span><\/span><\/span><\/p>\n

1.\u5217\u96c6:<\/span>INSERT<\/span>\u3001<\/span>UPDATE\u00a0<\/span>\u548c<\/span>\u00a0DELETE\u00a0<\/span>\u8bed\u53e5\u53ef\u4ee5\u901a\u8fc7\u540d\u79f0\u6765\u5f15\u7528\u7a00\u758f\u5217<\/span>.<\/span>\u4f46\u662f<\/span>,<\/span>\u60a8\u4e5f\u53ef\u4ee5\u67e5\u770b\u5e76\u5904\u7406\u8868\u4e2d\u7ec4\u5408\u4e3a\u4e00\u4e2a<\/span>\u00a0XML\u00a0<\/span>\u5217\u7684\u6240\u6709\u7a00\u758f\u5217<\/span>.<\/span>\u6b64\u5217\u79f0\u4e3a\u5217\u96c6<\/span>.<\/span><\/span><\/span><\/p>\n

2.\u7b5b\u9009\u7d22\u5f15:\u56e0\u4e3a\u7a00\u758f\u5217\u6709\u8bb8\u591a<\/span>\u00a0Null\u00a0<\/span>\u503c\u884c<\/span>,<\/span>\u6240\u4ee5\u5c24\u5176\u9002\u7528\u4e8e\u7b5b\u9009\u7d22\u5f15<\/span>.<\/span>\u7a00\u758f\u5217\u7684\u7b5b\u9009\u7d22\u5f15\u53ef\u4ee5\u4ec5\u4ec5\u5bf9\u5df2\u586b\u5145\u503c\u7684\u884c\u7f16\u5236\u7d22\u5f15<\/span>.<\/span>\u8fd9\u4f1a\u521b\u5efa\u4e00\u4e2a\u66f4\u5c0f\u3001\u66f4\u6709\u6548\u7684\u7d22\u5f15<\/span>.<\/span><\/span><\/span><\/p>\n

\u7a00\u758f\u5217\u548c\u7b5b\u9009\u7d22\u5f15\u4f7f\u5e94\u7528\u7a0b\u5e8f<\/span>(<\/span>\u5982<\/span>\u00a0Windows SharePoint Services<\/span>)<\/span>\u53ef\u4ee5\u901a\u8fc7<\/span>\u00a0SQL Server 2008\u00a0<\/span>\u6709\u6548\u5730\u5b58\u50a8\u548c\u8bbf\u95ee\u5927\u91cf\u7684\u7528\u6237\u5b9a\u4e49\u5c5e\u6027<\/span>.<\/span><\/span><\/span><\/p>\n

\n

\n

\u6ce8\u610f:<\/strong><\/span><\/span><\/span><\/p>\n

\u4e0b\u9762\u7684\u6570\u636e\u7c7b\u578b<\/span>\u4e0d\u80fd<\/span>\u6307\u5b9a\u4e3a<\/span>\u00a0SPARSE<\/span>\uff1a<\/span><\/span><\/span><\/p>\n

\n\n\n\n\n\n\n
\n

geography<\/span><\/span><\/span><\/p>\n<\/td>\n

\n

text<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

geometry<\/span><\/span><\/span><\/p>\n<\/td>\n

\n

timestamp<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

image<\/span><\/span><\/span><\/p>\n<\/td>\n

\n

user-defined data types<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

ntext<\/span><\/span><\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u7a00\u758f\u5217\u662f\u5bf9\u00a0Null\u00a0\u503c\u91c7\u7528\u4f18\u5316\u7684\u5b58\u50a8\u65b9\u5f0f\u7684\u666e\u901a\u5217.\u7a00\u758f\u5217\u51cf\u5c11\u4e86\u00a0Null\u00a0\u503c\u7684\u7a7a\u95f4\u9700\u6c42,\u4f46\u4ee3\u4ef7\u662f\u68c0\u7d22\u975e\u00a0Nu […]<\/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-221","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\/221","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=221"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/221\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}