SQL Server multiple version view version number

Today to query their own installed sqlserver2008 is R2 version, search the next, found that a lot of people query this problem, now recorded as follows, through the version of the command query

Also understand the older brother SQL Server version of the good, a look is very clear, record

1. View SQL Server 2005/2008 version number

Select SERVERPROPERTY (' ProductVersion '), serverproperty (' ProductLevel '), Serverproperty (' edition ')

The following is the SQL Server 2005 version number query results information:

Version Level edition

———— —- ——————-

9.00.3042.00 SP2 Enterprise Edition

The following table is the version number information for SQL Server 2005:

SQL Server 2005 version number SQL Server 2005 version description

———————– ——————————

2005.90.1399 RTM (Release to manufacturing)

2005.90.2047 SQL Server SP1

2005.90.3042 SQL Server SP2

2005.90.4035 SQL Server SP3

2005.90.5000 SQL Server SP4

The following table is the version number information for SQL Server 2008:

SQL Server 2008 version number SQL Server 2008 version 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)

Second, view SQL Server 2000 version number

Select SERVERPROPERTY (' ProductVersion '), serverproperty (' ProductLevel '), Serverproperty (' edition ')

The following is the SQL Server 2000 version number query results information:

Version Level edition

———— —- ——————-

8.00.2039 SP4 Enterprise Edition

The following table is the version number information for SQL Server 2000:

SQL Server 2000 version number SQL Server 2000 version description

———————– ——————————

2000.80.194.0 RTM (Release to manufacturing)

2000.80.384.0 SQL Server SP1

2000.80.534.0 SQL Server SP2

2000.80.760.0 SQL Server Sp3/sp3a

2000.8.00.2039 SQL Server SP4

Common methods for viewing SQL Server version numbers: @ @version

SELECT @ @version

Microsoft SQL Server 2000–8.00.2039 (Intel X86)

May 3 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)

As you can see, the @ @version version number results also contain the OS version information.

The following concepts are useful for understanding SQL Server behavior for parallel instances of SQL Server and for situations specific to SQL Server 2008 R2 and SQL Server 2008 parallel instances.

The standard product version format for SQL Server is MM.NN.BBBB.RR, where each fragment is defined as:

mm– Major Version

nn– Minor Version

bbbb– Build Number

rr– Internal Revision number

In each major or minor version of SQL Server, the version number is incremented to distinguish it from the previous version. This pair of versions is changed for a variety of purposes. This includes displaying version information in the user interface, controlling how files are replaced during an upgrade, and also acting as a mechanism for distinguishing functionality between subsequent versions.

SQL Server 2008 R2 is a minor upgrade to SQL Server 2008. This means that it shares the same major version number as SQL Server 2008 and increases the minor version number. The product version of SQL Server 2008 R2 is 10.50.BBBB.RR. By contrast, the product version of SQL Server 2008 is 10.0.BBBB.RR.