Not a long post but very handy query that can be used when you need to know the installed SQL Server product's version, edition, flavour, server name details.
SQL Query to get version details for installed Microsoft SQL Server:
SELECT
SERVERPROPERTY('productversion') AS 'Product Version',
SERVERPROPERTY ('productlevel') AS 'Product Level',