SQL Server versioning table correspondence
Is there a table in MSDN somewhere which shows the SQL Server correspondence values?
SELECT @@VERSION AS 'version', SERVERPROPERTY('ProductVersion')
In this query, the first column will return something like "Microsoft SQL Server XXXX (SPX) - N.N.N", and the second column will be in the form of "N.N.N".
How can I know the XXXX value from N.N.N?
Thanks