SQL Server Product Information

Objective:
The below query information retrieve your servername, sql server edition, Product Level like Service Pack version and Product Version number as well

Query:
select @@servername as ServerName,serverproperty('edition') as Edition,serverproperty('productlevel') as ProductLevel,
serverproperty('productversion') as ProductVersion