Hello friends, Its very confusion to know about Sql Server Versions. Here I am making it easy to understand SQL Server released Versions by Microsoft. Moreover, How to check SQL Server version by t-Sql Command on your computer.
You can check sql server version by following t-sql query.
-- T-SQL Query to get current installed version
SELECT @@VERSION
OUTPUT
-----------------------------------------------------
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)
(1 row affected)
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 |
If you have any query or question or topic on which, we might have to write an article for your interest or any kind of suggestion regarding this post, Just feel free to write us, by hit add comment button below or contact via Contact Us form.
Your feedback and suggestions will be highly appreciated. Also try to leave comments from your valid verified email account, so that we can respond you quickly.