Retrieving SQL Server Edition, Version and Service Pack Info

Tagged:

This is sample code. Add error handling and adjust to your requirements as necessary.

SELECT 
	SERVERPROPERTY('Edition') AS Edition,
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel