查看SQL SERVER 版本信息

方法一：

 

方法二：

 

 

方法三：

SELECT
SERVERPROPERTY('servername') AS 实例名,
SERVERPROPERTY('ProductVersion') AS 实例版本,
SERVERPROPERTY('Edition') AS 产品版本,
SERVERPROPERTY('ProductLevel') AS 版本级别,
@@VERSION AS 版本信息

 

 

 

SELECT SERVERPROPERTY('Edition') AS Edition ,
CASE SERVERPROPERTY('EditionID')
WHEN 1804890536 THEN 'Enterprise Edittion: CAL Lincenseing'
WHEN 1872460670 THEN 'Enterprise Edition: Core-based Licensing'
WHEN 610778273 THEN 'Enterprise Evaluation'
WHEN 284895786 THEN 'Business Intelligence'
WHEN -2117995310 THEN 'Developer'
WHEN -1592396055 THEN 'Express'
WHEN -133711905 THEN 'Express with Advanced Services'
WHEN -1534726760 THEN 'Standard'
WHEN 1293598313 THEN 'Web'
ELSE '' END AS License

 

方法四：
exec xp_msver

 

 

 

更多参考：SERVERPROPERTY (Transact-SQL)