sql version

sqlversion.sql

DECLARE @ProductVersion varchar(15);
                            DECLARE @Edition varchar(15);
                            DECLARE @EngineEdition smallint;
                            DECLARE @HostPlatform varchar(15);

                            SELECT @ProductVersion = CAST(SERVERPROPERTY('ProductVersion') AS varchar(15)),
                                @Edition = CAST(SERVERPROPERTY('Edition') AS varchar(15)),
                                @EngineEdition = CAST(SERVERPROPERTY('EngineEdition') AS smallint)

                            DECLARE @Version int
                            SET @Version = LEFT(@ProductVersion, CHARINDEX('.', @ProductVersion) - 1)

                            IF @Version >= 14
                            BEGIN
                                SELECT @HostPlatform = host_platform
                                FROM sys.dm_os_host_info
                            END
                            ELSE
                            BEGIN
                                SET @HostPlatform = 'Windows'
                            END

                            SELECT @ProductVersion AS ProductVersion,
                                   @Edition AS Edition,
                                   @EngineEdition AS EngineEdition,
                                   @HostPlatform AS HostPlatform