How to find the installed version of SQL Server. This query will give us the required version information of the sql server instance.
Select SERVERPROPERTY('MachineName') 'Hostname',SERVERPROPERTY('InstanceName') 'SQLInstanceName',left(@@version, CHARINDEX('(', @@version)-1) 'SQLProduct',SERVERPROPERTY('Edition')'Edition',SERVERPROPERTY('ProductLevel')'ProductLevel',SERVERPROPERTY('ProductVersion')'ProductVersion'Sample Output
Find SQL Server Build Versions for all SQL Server products, click here SQL Server Build Versions Detailed
