一、 引用nzperfect的查询sql server版本的语句:
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
根据版本返回如下:
1. Enterprise Edition (64-bit)Enterprise Edittion: CAL Lincenseing
这个是CAL Lincenseing,最大只支持40个CPU(含多核)
2. Enterprise Edition: Core-based Licensing (64-bit)Enterprise Edition: Core-based Licensing 无限制(含多核)
3. SERVERPROPERTY函数返回服务器基本数据信息,引用:
http://www.cnblogs.com/roboot/p/5805447.html
https://msdn.microsoft.com/zh-cn/library/ms174396.aspx
eg:
SELECT SERVERPROPERTY(