What are different SQL versions?

What are different editions of SQL Server?

SQL Server Editions1Enterprise Edition.2Standard Edition. ... 3MSDE. ... 4Personal Edition. ... 5Developer Edition. ... 6Enterprise Evaluation Edition. ... 7SQL Server CE. As you'd expect, SQL Server 2000 Windows CE Edition uses a different code base than other SQL Server editions do. ...

What is SQL and different types of SQL?

Type of SQL statements are divided into five different categories: Data definition language (DDL), Data manipulation language (DML), Data Control Language (DCL), Transaction Control Statement (TCS), Session Control Statements (SCS).

Which SQL version is best?

You use Standard Edition – because it supports 128GB RAM (and can even go beyond that for some internal stuff like query plans.) You want to stay here until 2025-2026 – this version has more years left in its support life than SQL Server 2012/2014, so you can install it once and stick around longer.

What is the current version of SQL?

The current version is Microsoft SQL Server 2019, released November 4, 2019. The RTM version is 15.0. 2000.5.