About SQL Server Versions

Introduction

I always very much confused about SQL Server Versions. To check the SQL Server version by TSQL we may run below script.

Script 01

Result

SQL Server Version : Microsoft SQL Server 2016 (SP2) (KB4052908) – 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )
ProductLevel: SP2

Script 02

Result

Script 03

Result

List of Microsoft SQL Server Release Version

# Version Year Release Name
1). 1.0 (OS/2) 1989 SQL Server 1.0 (16-bit)
2). 1.1 (OS/2) 1991 SQL Server 1.1 (16-bit)
3). 4.2A (OS/2) 1992 SQL Server 4.2A (16-bit)
4). 4.2B (OS/2) 1993 SQL Server 4.2B (16-bit)
5). 4.21a (WinNT) 1993 SQL Server 4.21a
6). 6 1995 SQL Server 6.0
7). 6.5 1996 SQL Server 6.5
8). 7 1998 SQL Server 7.0
9). 0 1999 SQL Server 7.0 OLAP Tools
10). 8 2000 SQL Server 2000
11). 8 2003 SQL Server 2000 64-bit Edition
12). 9 2005 SQL Server 2005
13). 10 2008 SQL Server 2008
14). 10.25 2010 Azure SQL database (initial release)
15). 10.5 2010 SQL Server 2008 R2
16). 11 2012 SQL Server 2012
17). 12 2014 SQL Server 2014
18). 13 2016 SQL Server 2016
19). 14 2017 SQL Server 2017
20). Upcoming 2019 SQL Server 2019

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *