Table of Contents

 

Overview

 

Name Version Number Release Date Code Name
SQL Server 2016: What's New 13.00.1601.5 1 Jun 2016 2016
SQL Server 2014 12.0.2000.00 18 Mar 2014 Hekaton
SQL Server 2012 11.0.2100.60 1 April 2012 Denali
SQL Server 2008 R2 10.50.1600.1 3rd May 2010 Kilimanjaro
SQL Server 2008 10.00.1600.22 6th Aug 2008 Katmai
SQL Server 2005 9.00.1399 Sep. 2005 Yukon
SQL Server 2000 8.00.2039 2000 Shiloh
SQL Server 7.0 OLAP Tools 1999 Palato mania
SQL Server 7.0 1998 Sphinx
SQL Server 6.5 1996 Hydra
SQL Server 6.0 1995 SQL95
SQL Server 4.21 1993 SQLNT
SQL Server 1.1 1991
SQL Server 1.0 1989

 

Service Pack editions

 

Name RTM/No SP SP1 SP2 SP3 SP4
SQL Server 2016: What's New 13.00.1601.5 13.0.4001.0
SQL Server 2014 12.00.2000.8 12.00.4100.1 12.00.5000
SQL Server 2012 11.0.2100.60 11.0.3000.00 11.0.5569.0 11.0.6020
SQL Server 2008 R2 10.50.1600.0 10.50.2500 10.50.4000.0 10.50.6000.34
SQL Server 2008 10.00.1600.22 10.0.2531.0 10.0.4000.0 10.00.5500 10.0.6000.29
SQL Server 2005 9.00.1399 9.00.2047 9.00.3042 9.00.4035 9.00.5000
SQL Server 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039
SQL Server 7.0 7.00.623 7.00.699 7.00.842 7.00.961 7.00.10

 

References

For more complete information see

 

Querying for version/edition info

Get the current installed version of SQL Server:

SELECT @@VERSION AS Version

or nicer:

SELECT 
	SERVERPROPERTY('Edition') AS Edition,
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel

shows result like: "9.00.3054.00, SP2, Developer Edition."

or e.g.

or e.g. 

select @@microsoftversion / 0x01000000, @@microsoftversion & 0xFFFF

 

See Also

 

Other Languages

This article is also available in the following languages: