Skip to content

SQL Server 版本号

查询完整版本信息

Select @@version

(结果)

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
 Apr 2 2010 15:48:46 
 Copyright (c) Microsoft Corporation
 Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

分解的详细版本信息

SELECT SERVERPROPERTY('productversion') as "version", 
SERVERPROPERTY ('productlevel') as "level",
SERVERPROPERTY ('edition') as "edition";

(结果)

10.50.1600.1 RTM Enterprise Edition (64-bit)

 


MS SQL Server中,版本号通常[大版本.小版本.累积更新]这种形式命名的,下面对应的版本列出来,以方便查阅。

Version patternSQL Product
12.0.x.xSQL Server 2014
11.0.x.xSQL Server 2012
10.50.x.xSQL Server 2008 R2
10.00.x.xSQL Server 2008
9.00.x.xSQL Server 2005
8.00.x.xSQL Server 2000
 主版本号 版本名称RTM (no SP)SP1SP2SP3SP4
13.0 SQL Server 2016
codename ?
13.0.1601.513.0.4001.0
or 13.1.4001.0
12.0 SQL Server 2014
codename HekatonSQL14
12.0.2000.812.0.4100.1
or 12.1.4100.1
12.0.5000.0
or 12.2.5000.0
11.0 SQL Server 2012
codename Denali
11.0.2100.6011.0.3000.0
or 11.1.3000.0
11.0.5058.0
or 11.2.5058.0
11.0.6020.0
or 11.3.6020.0
10.50 SQL Server 2008 R2
codename Kilimanjaro
10.50.1600.110.50.2500.0
or 10.51.2500.0
10.50.4000.0
or 10.52.4000.0
10.50.6000.34
or 10.53.6000.34
10.0 SQL Server 2008
codename Katmai
10.0.1600.2210.0.2531.0
or 10.1.2531.0
10.0.4000.0
or 10.2.4000.0
10.0.5500.0
or 10.3.5500.0
10.0.6000.29
or 10.4.6000.29
9.0 SQL Server 2005
codename Yukon
9.0.1399.069.0.20479.0.30429.0.40359.0.5000
8.0 SQL Server 2000
codename Shiloh
8.0.1948.0.3848.0.5328.0.7608.0.2039
7.0 SQL Server 7.0
codename Sphinx
7.0.6237.0.6997.0.8427.0.9617.0.1063

 

相关资源,更详细,更全列表:

 

微软官方:

How to determine the version, edition and update level of SQL Server and its components”>How to determine the version, edition and update level of SQL Server and its components  
https://support.microsoft.com/en-us/kb/321185

 

SQL Server 声明周期: https://support.microsoft.com/en-us/lifecycle/search/?c2=1044

http://download.microsoft.com/download/7/C/1/7C1BA242-14B5-48AE-9A99-7CE4FE9DAAF9/SQL%20Server%20Builds%20V3.xlsx

发表评论

电子邮件地址不会被公开。 必填项已用*标注

一点简单的验证. 谢谢 * 验证时间已超时。请刷新验证码。