sql server版本号
In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the hotfixes and CUs of SQL Server 2008 R2 and earlier versions.
在本文中，我将展示识别SQL Server版本号及其版本的不同方法。 此外，我还列出了已知SQL Server版本号，Service Pack（SP）和累积更新的列表（MS SQL Server 2019、2017的CU）。 我没有包括SQL Server 2008 R2和更早版本的修补程序和CU。
Before going through the list, let us understand the terms RTM, Service Packs, and Cumulative Update.
在浏览列表之前，让我们了解RTM ， Service Pack和累积更新的术语。
RTM: RTM is the acronym of release to manufacturing. It is also known as “going gold”. This term is used when the product is ready to be delivered. This build may be digitally signed that allows users to verify the authenticity of software which they had purchased. RTM is the precedence of the General Availability (GA).
RTM： RTM是发布到制造的缩写。 它也被称为“走金”。 当准备好交付产品时使用此术语。 可以对该版本进行数字签名，以允许用户验证他们购买的软件的真实性。 RTM是通用（GA）的优先级。
Service Pack: A Service Pack (SP) is a collection of updates, hotfixes or it can be the enhancement to the existing software program. Prior to SQL Server 2017, Microsoft often released service packs based on the issues and feedbacks reported by the users. The service pack is considered a stable version and usually released after one or two years after the product’s release. Service packs are delivered in the single installable package.
Service Pack： Service Pack（SP）是更新，修补程序的集合，也可以是对现有软件程序的增强。 在SQL Server 2017之前，Microsoft经常根据用户报告的问题和反馈发布Service Pack。 该Service Pack被认为是稳定版本，通常在产品发布后一两年后发布。 Service Pack以单个可安装软件包的形式提供。
Cumulative Update: Cumulative Update is a rollup of multiple hotfixes. Cumulative updates are tested as a group. When you’re building a new SQL Server from scratch, then it is advisable to apply all the recent service packs and cumulative updates.
累积更新：累积更新是多个修补程序的汇总。 累积更新将作为一个整体进行测试。 从头开始构建新SQL Server时，建议应用所有最新的Service Pack和累积更新。
The following is the list of SQL Server version number, release type, and release date:
以下是SQL Server版本号，发行类型和发行日期的列表：
|
SQL Server release |
Version Number |
Type |
Release Date |
|
SQL Server 2019 |
15.0.2000.5 |
RTM |
2019-11-04 |
|
SQL Server 2017 |
14.0.1000.169 |
RTM |
2017-10-02 |
|
CU 17 |
Cumulative Update (Note: After SQL Server 2017, |
2019-10-08 |
|
|
SQL Server 2016 |
13.0.1601.5 |
RTM |
2016-06-01 |
|
13.0.4001.0 |
Service pack 1 |
2016-11-16 |
|
|
13.0.5026.0 |
Service pack 2 |
2018-04-24 |
|
|
SQL Server 2014 |
12.0.2000.8 |
RTM |
2014-04-01 |
|
12.0.4100.1 |
Service pack 1 |
2015-05-14 |
|
|
12.0.5000.0 |
Service pack 2 |
2016-07-11 |
|
|
12.0.6024.0 |
Service pack 3 |
2018-10-30 |
|
|
SQL Server 2012 |
11.0.2100.60 |
RTM |
2012-03-06 |
|
11.0.3000.0 |
Service pack 1 |
2012-11-06 |
|
|
11.0.5058.0 |
Service pack 2 |
2014-06-10 |
|
|
11.0.6020.0 |
Service pack 3 |
2015-11-23 |
|
|
11.0.7001.0 |
Service pack 4 |
2017-10-05 |
|
SQL Server版本 |
版本号 |
类型 |
发布日期 |
|
SQL Server 2019 |
15.0.2000.5 |
RTM |
2019-11-04 |
|
SQL Server 2017 |
14.0.1000.169 |
RTM |
2017-10-02 |
|
铜17 |
累积更新（注意：SQL Server 2017之后， |
2019-10-08 |
|
|
SQL Server 2016 |
13.0.1601.5 |
RTM |
2016-06-01 |
|
13.0.4001.0 |
服务包1 |
2016-11-16 |
|
|
13.0.5026.0 |
Service Pack 2 |
2018-04-24 |
|
|
SQL Server 2014 |
12.0.2000.8 |
RTM |
2014-04-01 |
|
12.0.4100.1 |
服务包1 |
2015-05-14 |
|
|
12.0.5000.0 |
Service Pack 2 |
2016-07-11 |
|
|
12.0.6024.0 |
Service Pack 3 |
2018-10-30 |
|
|
SQL Server 2012 |
11.0.2100.60 |
RTM |
2012-03-06 |
|
11.0.3000.0 |
服务包1 |
2012-11-06 |
|
|
11.0.5058.0 |
Service Pack 2 |
2014-06-10 |
|
|
11.0.6020.0 |
Service Pack 3 |
2015-11-23 |
|
|
11.0.7001.0 |
Service Pack 4 |
2017-10-05 |
如何识别SQL Server版本号 (How to identify the SQL Server version number)
We can identify the SQL Server version numbers using the following methods:
我们可以使用以下方法识别SQL Server版本号：
- SQL Server Management Studio SQL Server管理Studio
- SQL Server Configuration Manager SQL Server配置管理器
- Windows Registry Windows注册表
- T-SQL query T-SQL查询
- SQL Server error log file SQL Server错误日志文件
- PowerShell command PowerShell命令
方法1 –使用SSMS识别SQL Server版本号 (Method 1 – Identify SQL Server version number using SSMS)
First, open SQL Server Management Studio and connect to the Database Engine. See the following image:
首先，打开SQL Server Management Studio并连接到数据库引擎。 见下图：
Right-click on an instance name and select Properties. See the following image:
右键单击实例名称，然后选择属性 。 见下图：
In the Server Properties dialog box, you can see in opposite to Version. Alternatively, you can see the version in Object Explorer. See the following image:
在“ 服务器属性”对话框中，可以在“ 版本”的对面看到。 或者，您可以在对象资源管理器中查看版本。 见下图：
方法2 – SQL Server配置管理器 (Method 2 – SQL Server Configuration Manager)
To obtain the SQL Server version numbers, open SQL Server Configuration Manager. Click on SQL Server Services. Right-click on SQL Server instance, SQLServer (SQL2017) in my case, and choose Properties. See the following screenshot:
要获取SQL Server版本号，请打开SQL Server配置管理器。 单击“ SQL Server服务” 。 右键单击我的实例中SQL Server实例SQLServer（SQL2017） ，然后选择属性 。 请参见以下屏幕截图：
In Properties dialog box, click on the Advanced tab. You can see the SQL Server edition in Stock Keeping Unit Name text box and its version number in the Version text box. See the following image:
在“ 属性”对话框中，单击“ 高级”选项卡。 您可以在“ 库存单位名称”文本框中看到SQL Server版本，在“ 版本”文本框中看到其版本号。 见下图：
方法3 –使用Windows注册表 (Method 3 – Using Windows Registry)
To obtain the SQL Server version numbers, open Registry Editor and find the registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.MSSQLSERVER\Setup
若要获取SQL Server版本号，请打开注册表编辑器并找到注册表项： HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL14.MSSQLSERVER \ Setup
In the key, the value of PatchLevel indicates the current version number of SQL Server. See the following image:
在键中， PatchLevel的值指示SQL Server的当前版本号。 见下图：
方法4 – T-SQL查询 (Method 4 – T-SQL query)
To obtain the SQL Server version numbers using T-SQL, execute the following query in the SQL Server Management Studio:
若要使用T-SQL获取SQL Server版本号，请在SQL Server Management Studio中执行以下查询：
-
SELECT @@version AS [SQL Server version number];
-
GO
Following is the output:
以下是输出：
Microsoft SQL Server 2017 (RTM) – 14.0.1000.169 (X64)
Aug 22 2017 17:04:49
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0
(Build 17763: ) (Hypervisor)
Microsoft SQL Server 2017（RTM）– 14.0.1000.169（X64）
2017年8月22日17:04:49
版权所有（C）2017 Microsoft Corporation
Windows 10 Pro 10.0上的Developer Edition（64位）
（内部版本17763：）（管理程序）
If you run the same query on Azure instance, the following should be the output:
如果在Azure实例上运行相同的查询，则应为以下输出：
Microsoft SQL Azure (RTM) – 12.0.2000.8
Oct 12 2019 22:46:48
Copyright (C) 2019 Microsoft Corporation
Microsoft SQL Azure（RTM）– 12.0.2000.8
2019年10月12日22:46:48
版权所有（C）2019 Microsoft Corporation
方法5 – SQL Server错误日志文件 (Method 5 – SQL Server error log file)
To obtain the SQL Server version numbers from the error log file, open the ERRORLOG.txt file of SQL Server. The default location of the ERRORLOG file is C:\<InstanceRootDirectory>\<MajorBuildVersion>.MSSQLSERVER\MSSQL\Log. I have installed the SQL Server using default settings; therefore, the ERRORLOG file is in C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Log directory.
要从错误日志文件中获取SQL Server版本号，请打开SQL Server的ERRORLOG.txt文件。 ERRORLOG文件的默认位置是C：\ <InstanceRootDirectory> \ <MajorBuildVersion> .MSSQLSERVER \ MSSQL \ Log 。 我已经使用默认设置安装了SQL Server。 因此，ERRORLOG文件位于C：\ Program Files \ Microsoft SQL Server \ MSSQL14.SQL2017 \ MSSQL \ Log目录中。
Open the ERRORLOG file using Notepad or any other text editor, and you can see the SQL Server edition, its version number, and build number on the first line of the ERRORLOG. See the following image:
使用记事本或任何其他文本编辑器打开ERRORLOG文件，您可以在ERRORLOG的第一行上看到SQL Server版本，其版本号和内部版本号。 见下图：
方法6 – PowerShell命令 (Method 6 – PowerShell Command)
To obtain the SQL Server version numbers using PowerShell, execute the following command:
要使用PowerShell获取SQL Server版本号，请执行以下命令：
-
Invoke-Sqlcmd -ServerInstance "Nisarg-PC" -Query "Select @@version"
Following is the screenshot of the output:
以下是输出的屏幕截图：
结论 (Conclusion)
In this short article, I have explained what RTM, Service Packs, and Cumulative Updates are. I have also included the list of major SQL server versions and their service packs with respective build numbers. Furthermore, I have explained the different methods to identify the SQL Server build number and its edition.
在这篇简短的文章中，我解释了什么是RTM，Service Pack和累积更新。 我还列出了主要SQL Server版本及其包含相应内部版本号的Service Pack的列表。 此外，我已经解释了识别SQL Server内部版本号及其版本的不同方法。
