SQL Server versioning table correspondence
00:41 06 Feb 2026

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

sql-server