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.