For more complete information see
Get the current installed version of SQL Server:
SELECT @@VERSION AS Version
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel
shows result like: "9.00.3054.00, SP2, Developer Edition."
select @@microsoftversion / 0x01000000, @@microsoftversion & 0xFFFF
This article is also available in the following languages:
adicionado link ao Guia de Sobrevivencia do SQL Server
Prashant Jha edited Revision 45. Comment: Added version no. for SQL 2005, 2008 and 2008 R2
ganeshkuppuswamy edited Revision 53. Comment: Code name missed for SQL Versions
ganeshkuppuswamy edited Revision 54. Comment: Altered code name
Savannah Phillips edited Revision 59. Comment: added link to the most complete list of SQL releases I've found so far.
perfecto muy util
Thank you for this summary. I was wondering, which version of sql is best to use and easiest to deploy?
yottun8 edited Revision 60. Comment: Added Japanese version.