SQL versions include: 1. sql server2000; 2. sql server2005; 3. sql server2008; 4. sql server2008R2; 5. sql server2012; 6. sql server2014; 7. sql server2016, etc.
The more important versions of SQL Server are: 2000, 2005, 2008, 2012, 2014, 2016. Each version is divided into enterprise version, development version Edition, Professional Edition, Personal Edition, etc., contain different components. The new SQL Server 2016 has five versions: Enterprise Edition, Standard Edition, Developer Edition, Web Edition, and Express Edition.
sql server2000: All update services have been stopped in April 2014.
sql server2005: Currently using many database versions without smart prompts.
sql server2008: The version currently used by many servers, with intelligent prompts.
sql server2008R2: Currently the server is widely used, with intelligent prompts. The R2 flag indicates that this is an intermediate version of SQL Server, not a major version.
sql server2012: The performance has been optimized and the processing speed is faster.
sql server2014: This version has many new special effects and is very useful.
sql server2016: Full encryption technology (Always Encrypted), JSON support, multiple TempDB database files
The above is the detailed content of What are the sql server versions?. For more information, please follow other related articles on the PHP Chinese website!