sql server 2000 版本信息查询

广告：阿里云采购优惠专区

use master

(1)
exec xp_msver

Index Name Internal_Value Character_Value
---------------------------------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.2039
3 Language 2052 中文(中国)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.2039.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL ? 1988-2004 Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft? is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 133627904 NULL
15 WindowsVersion 248381957 5.2 (3790)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 511 511 (536301568)
20 Product ID NULL NULL

(2)
select @@version

---------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

SQL Server的版本和补丁号对应关系如下：
8.00.194 －——————SQL Server 2000 RTM
8.00.384 －——————(SP1)
8.00.534 －——————(SP2)
8.00.760 －——————(SP3)

(3)

select 版本=serverproperty('productversion'),产品级别=serverproperty('productlevel'),版本=serverproperty('edition')

-------------------------------------------
版本 产品级别 版本
8.00.2039 SP4 Enterprise Edition

select serverproperty('productlevel')

广告：阿里云新人采购专场