Select @@version

SELECT 
SERVERPROPERTY('productversion'), 
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition') 

SET @EditionID          = SERVERPROPERTY('EditionID') 
SET @ProductVersion     = CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductVersion'))  
SET @ProductLevel       = CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductLevel'))  
SET @UpdateLevel        = ISNULL(CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductUpdateLevel')),'') 
SET @UpdateRef          = ISNULL(CONVERT(NVARCHAR(20),SERVERPROPERTY('@UpdateRef')),'') 
SET @Edition            = CONVERT(NVARCHAR(100),SERVERPROPERTY('Edition')) 

-- SQLSERVER2005： 9.00.5000.00 SP4 Standard Edition (64-bit)
-- SQLSERVER2000:  8.00.2039

-- SQLserver express 不支持agent
-- SQLserver stand server 不支持 index rebuild online

SELECT    @ProductName =  
        CASE SUBSTRING(@ProductVersion,1,4) 
            WHEN '14.0' THEN 'SQL Server 2017' 
            WHEN '13.0' THEN 'SQL Server 2016'  
            WHEN '12.0' THEN 'SQL Server 2014'  
            WHEN '11.0' THEN 'SQL Server 2012'  
            WHEN '10.5' THEN 'SQL Server 2008 R2'  
            WHEN '10.0' THEN 'SQL Server 2008'   
        END, 
        @TheLastVersion =  
        CASE SUBSTRING(@ProductVersion,1,4) 
            WHEN '14.0' THEN 'SQL Server 2017 RTM'  
            WHEN '13.0' THEN 'SQL Server 2016 SP1'  
            WHEN '12.0' THEN 'SQL Server 2014 SP2'  
            WHEN '11.0' THEN 'SQL Server 2012 SP4'  
            WHEN '10.5' THEN 'SQL Server 2008 R2 SP3'  
            WHEN '10.0' THEN 'SQL Server 2008 SP4'  
        END

-- 目录名和版本对应：
-- C:\Program Files (x86)\Microsoft SQL Server\130\Shared
-- 本地注册服务器文件保存路径：
   C:\Users\用户名\AppData\Roaming\Microsoft\SQL Server Management Studio\RegSrvr.xml

-- 查询数据库兼容性级别：
SELECT name, compatibility_level
FROM sys.databases
WHERE name = db_name();
-- 修改：
ALTER DATABASE [DB3] SET COMPATIBILITY_LEVEL = 140;