SQL Server 版本号汇总

通过SSMS连接Sql servr，查看实例的版本就能知道当前SQL Server的版本号了。

 

	RTM (no SP)	SP1	SP2	SP3	SP4
SQL Server 2014      codename Hekaton SQL14	12.00.2000.8
SQL Server 2012      codename Denali	11.00.2100.60	11.00.3000.0	11.00.5058.0
SQL Server 2008 R2      codename Kilimanjaro	10.50.160010.50.1600.1	10.50.2500.0 or 10.51.2500.0	10.50.4000.0 or 10.52.4000.0
SQL Server 2008      codename Katmai	10.00.1600.22	10.00.2531.0	10.00.4000.0	10.00.5500.0
SQL Server 2005      codename Yukon	9.00.1399.06	9.00.2047	9.00.3042	9.00.4035	9.00.5000
SQL Server 2000      codename Shiloh	8.00.194	8.00.384	8.00.532	8.00.760	8.00.2039
SQL Server 7.0      codename Sphinx