sql server版本号_识别SQL Server版本号的不同方法

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, Microsoft does not release the service packs.	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 </