The current version of SQL Server is SQL Server 2005. SQL Server 2008 will be coming out later this year.
The prior versions are:
SQL Server 2000
SQL Server 7
SQL Server 6.5
SQL Server 6.0
SQL Server 5.0
SQL Server 4.2
SQL Server 4.0
(There are more, but this is about 15-20 years worth of history.)
The most common versions to see in production today are SQL Server 7-2005. Pretty much nothing older than SQL 6.5 is still in use.
There are also several editions of each version. They are:
Express Edition - SQL 2000 and greater (called MSDE for SQL 2000)
Workgroup Edition - SQL 2000 and greater
Standard Edition - Since at least SQL 6.5
Enterprise Edition - Since at least SQL 6.5
Last Wiki Answer Submitted: July 3, 2008 5:59 am by Denny Cherry64,520 pts.
All Answer Wiki Contributors: Denny Cherry64,520 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
That is assuming you are discussing Microsoft SQL Server (which is probably the case). There are other publishers as well: Gupta SQL Server is still around, as is MySQL (open source) to name but two; there are others…
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
That is assuming you are discussing Microsoft SQL Server (which is probably the case). There are other publishers as well: Gupta SQL Server is still around, as is MySQL (open source) to name but two; there are others…
Please i get to do my ISAS and the topic tell me to find out the features and application of sql server
Bejo,
Then you should go to Microsoft’s website and find the page which has all the features listed by edition.