SQL Server version number view SQL statements (SQL Server 2000 & 2005 & 2008)

Today, I want to query whether my own sqlserver2008 version is R2. After searching, I found that many people have queried this problem. Now the record is as follows: use the version command to query
At the same time, I also learned about the corresponding version of my brother SQL server, which is very clear at a glance and recorded

1. View SQL Server 2005/2008 version

The code is as follows:
Select serverproperty ('productversion'), serverproperty ('productlevel'), serverproperty ('version ')

The query result of SQL Server 2005 is as follows:

Version level edition
-------------
9.00.3042.00 SP2 Enterprise Edition

The following table lists the SQL Server 2005 version numbers:

SQL Server 2005 version 2005 description
------------------
2005.90.1399 RTM (Release to Manufacturing)
2005.90.2047 SQL Server 2005 SP1
2005.90.3042 SQL Server 2005 SP2
2005.90.4035 SQL Server 2005 SP3
2005.90.5000 SQL Server 2005 SP4

The following table lists the SQL Server 2008 version numbers:

SQL Server 2008 version 2008 Description
------------------
10.0.1600.22 RTM
10.00.2531.00 SQL Server 2008 SP1
10.00.4000.00 SQL Server 2008 SP2
10.50.1600.1 SQL Server 2008 R2 (RTM)

II. View SQL Server 2000 version

The code is as follows:
Select serverproperty ('productversion'), serverproperty ('productlevel'), serverproperty ('version ')

The query result of SQL Server 2000 is as follows:

Version level edition
-------------
8.00.2039 SP4 Enterprise Edition

The following table lists the version numbers of SQL Server 2000:

SQL Server 2000 Version 2000 description
------------------
2000.80.194.0 RTM (Release to Manufacturing)
2000.80.384.0 SQL Server 2000 SP1
2000.80.534.0 SQL Server 2000 SP2
2000.80.760.0 SQL Server 2000 SP3/SP3a
2000.8.00.2039 SQL Server 2000 SP4

Common method for viewing SQL Server version :@@Version

The code is as follows:
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)
Microsoft SQL Server 2005-9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

It can be seen that the @ version result also contains the OS version information.

The following concepts are useful for understanding SQL Server behaviors of SQL Server parallel instances and SQL Server 2008 R2 and SQL Server 2008 parallel instances.

The standard SQL Server product version is in the format of MM. nn. bbbb. rr. Each segment is defined:

MM-Main version

Nn-next version

Bbbb-internal version number

Rr-internal revision version number

This version is added to each major or minor version of SQL Server to distinguish it from the previous version. This version was changed for multiple purposes. This includes displaying version information on the user interface, controlling the method of replacing files during the upgrade, and also distinguishing functions between subsequent versions.

SQL Server 2008 R2 is a secondary upgrade of SQL Server 2008. This means that it shares the same master version number with SQL Server 2008 and adds the minor version number. The product version of SQL Server 2008 R2 is 10.50.bbbb.rr. In comparison, the SQL Server 2008 product version is 10.0.bbbb.rr.