-- 方法 1:SERVERPROPERTY(推薦,結構化)
SELECT
SERVERPROPERTY('ProductVersion') AS Version,
SERVERPROPERTY('ProductLevel') AS Level, -- RTM/SP1/SP2/CU...
SERVERPROPERTY('Edition') AS Edition; -- Express/Standard/Enterprise
-- 方法 2:@@VERSION(單字串,含 OS、建置日期)
SELECT @@VERSION;
主版本.次版本.建置號.修訂號 (MM.nn.bbbb.rr)
| 產品 | 版本號範圍 | 關鍵建置號 | 說明 |
|---|---|---|---|
| SQL Server 2000 | 8.00.xxxx | 8.00.194 (RTM), .384 (SP1), .534 (SP2), .760 (SP3/3a), .2039 (SP4) | 最後支援 2013/4/9 |
| SQL Server 2005 | 9.00.xxxx | 9.00.1399 (RTM), .2047 (SP1), .3042 (SP2), .4035 (SP3), .5000 (SP4) | 最後支援 2016/4/12 |
| SQL Server 2008 | 10.00.xxxx | 10.00.1600 (RTM), .2531 (SP1), .4000 (SP2), .5500 (SP3), .6000 (SP4) | 最後支援 2019/7/9 |
| SQL Server 2008 R2 | 10.50.xxxx | 10.50.1600 (RTM), .2500 (SP1), .4000 (SP2), .6000 (SP3) | 次版本 50 區分 R2 |
| SQL Server 2012 | 11.00.xxxx | 11.00.2100 (RTM), .3000 (SP1), .5058 (SP2), .6020 (SP3), .7001 (SP4) | |
| SQL Server 2014 | 12.00.xxxx | 12.00.2000 (RTM), .2569 (SP1), .5571 (SP2), .6329 (SP3) | |
| SQL Server 2016 | 13.00.xxxx | 13.00.1601 (RTM), .4001 (SP1), .5026 (SP2), .5882 (SP3/CU) | |
| SQL Server 2017 | 14.00.xxxx | 14.00.1000 (RTM), .3049 (CU20+ 合併 CU 模式) | 首支 Linux/容器 |
| SQL Server 2019 | 15.00.xxxx | 15.00.2000 (RTM), .4000 (CU10+) | Big Data Clusters、UTF-8 排序 |
| SQL Server 2022 | 16.00.xxxx | 16.00.1000 (RTM), .1105 (CU10+) | Azure 整合、Ledger、JSON 改進 |
SELECT SERVERPROPERTY('ProductMajorVersion'), SERVERPROPERTY('ProductMinorVersion'), SERVERPROPERTY('ProductBuild'), SERVERPROPERTY('ProductBuildType');(2017+)@@VERSION 中 RTM / SP / CU 關鍵字。ALTER DATABASE ... SET COMPATIBILITY_LEVEL = 160;(2022)控制查詢優化器行為,獨立於引擎版本。SELECT * FROM sys.dm_exec_valid_use_hints; 查看支援的 Query Hint。掌握版本號解讀,是 DBA 進行升級規劃、相容性測試、安全修補的基礎技能。