{"id":645,"date":"2010-11-12T13:46:33","date_gmt":"2010-11-12T05:46:33","guid":{"rendered":""},"modified":"2014-03-11T22:34:02","modified_gmt":"2014-03-11T14:34:02","slug":"%e6%9f%a5%e7%9c%8b%e5%ae%89%e8%a3%85sql-server-2000%e4%bb%80%e4%b9%88%e7%89%88%e6%9c%ac","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2010\/11\/12\/645.htm","title":{"rendered":"\u67e5\u770b\u5b89\u88c5SQL SERVER 2000\u4ec0\u4e48\u7248\u672c"},"content":{"rendered":"

\u5982\u4f55\u67e5\u770bSQL Server2000\u7684\u7248\u672c\u53f7<\/p>\n

\n\n\n\n
\n

 <\/p>\n

   select serverproperty(‘Edition’)<\/p>\n

   select serverproperty(‘ProductLevel’)<\/p>\n

   serverproperty\u51fd\u6570\u8fd4\u56de\u6709\u5173\u670d\u52a1\u5668\u5b9e\u4f8b\u7684\u5c5e\u6027\u4fe1\u606f\uff0c\u8be6\u7ec6\u64cd\u4f5c\u53ef\u4ee5\u67e5\u770bSQL Server2000\u7684\u8054\u673a\u5e2e\u52a9<\/p>\n

2.\u5982\u4f55\u67e5\u770bSQL Server2000\u662f\u5426\u6253\u8865\u4e01\uff0c\u53ca\u8865\u4e01\u7684\u7248\u672c<\/p>\n

\u6709\u4e24\u79cd\u65b9\u6cd5\u53ef\u4ee5\u5b9e\u73b0:\u4e00\u79cd\u662f\u67e5\u770bMS-SQL\u7684\u5173\u4e8e\u4fe1\u606f\uff1b\u4e00\u79cd\u662f\u5229\u7528MS-SQL\u7684\u8bed\u53e5\u6765\u5b9e\u73b0(Select @@Version)\u6216\u8005\uff08SELECT SERVERPROPERTY(‘ProductVersion’)\uff09<\/p>\n

Microsoft SQL Server   2000 – 8.00.194 (Intel X86) Aug   6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation   Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)<\/p>\n

8.00.194 \uff0d——————SQL Server 2000 RTM\uff08\u672a\u5b89\u88c5\u8865\u4e01\uff09<\/p>\n

8.00.384 \uff0d——————(SP1)<\/p>\n

8.00.534 \uff0d——————(SP2)<\/p>\n

8.00.760 \uff0d——————(SP3)<\/p>\n

8.00.2039 \uff0d——————(SP4)  <\/p>\n

   \u53e6\u5916\u901a\u8fc7Copyright (c) 1988-2000 Microsoft Corporation\u4e2d\u7684\u65e5\u671f\u4e5f\u53ef\u4ee5\u770b\u51faSQL Server2000\u662f\u5426\u6253\u8865\u4e01\uff0c\u4f46\u5728\u8fd9\u91cc\u4f53\u73b0\u4e0d\u51fa\u8865\u4e01\u7684\u7248\u672c,\u540e\u9762\uff08\uff22uild 2600:Service Pack 2\uff09\u4e3a\u64cd\u4f5c\u7cfb\u7edf\u8865\u4e01<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u5982\u4f55\u67e5\u770bSQL Server2000\u7684\u7248\u672c\u53f7      select serverproperty(‘Edition’)    select serverproper…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-645","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=645"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/645\/revisions"}],"predecessor-version":[{"id":66483,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/645\/revisions\/66483"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=645"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=645"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}