SQL Server Versions

Seeing the Version from the SQL Server Studio, we can easily identify what are the versions of SQL Server that the particular machine have installed

1

2

3

4

5

6

7

8

9

80 = SQL Server 2000 = 8.00.xxxx

90 = SQL Server 2005 = 9.00.xxxx

100 = SQL Server 2008 = 10.00.xxxx

105 = SQL Server 2008 R2 = 10.50.xxxx

110 = SQL Server 2012 = 11.00.xxxx

120 = SQL Server 2014 = 12.00.xxxx

130 = SQL Server 2016 = 13.00.xxxx

140 = SQL Server 2017 = 14.00.xxxx

150 = SQL Server 2019 = 15.00.xxxx

DinePlan