SQL server Versiyonunu ögrenmek için 

set nocount on
go 

select @@version
go 

select 'Edition: ' + convert(char(30), serverproperty('Edition'))
go 

select 'Product Version: ' + convert(char(20), serverproperty('ProductVersion'))
go 

select 'Product Level: ' + convert(char(20),serverproperty('ProductLevel'))
go 

set nocount off
go 

Çıktı :

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)   Sep 16 2010 19:43:16   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

Edition: Express Edition (64-bit)      

Product Version: 10.0.4000.0         

Product Level: SP2