Question

如何检查我们是否安装了 sql server 完整版或客户端版本？

2

0

Answer 1

您可以使用Select @@version

或获取更多数据：

SELECT  SERVERPROPERTY('productversion')AS Product_version, 
        SERVERPROPERTY('productlevel')AS Product_level,
        SERVERPROPERTY('edition')AS Edition

Answer 2

获取更多详细信息，如版本，Service Pack。

select SERVERPROPERTY('MachineName')as 'Host Name', 
        SERVERPROPERTY('ServerName') as 'Instance Name' , 
        SERVERPROPERTY('IsCered') as 'Cer' , 
    SERVERPROPERTY('Edition') as 'Edition',
        SERVERPROPERTY('ProductVersion') as 'version',
    SERVERPROPERTY('Productlevel') as 'Service Pack',   
        SERVERPROPERTY('LicenseType') as 'LicenseType' ,
        SERVERPROPERTY('NumLicenses') as 'NumLicenses'

Answer 3

我已经创建了这个查询，它会返回这样的数据：SQL Server 2016 标准版（64 位）13.0.5237.0 SP2

DECLARE 
    @productver VARCHAR(50) = (SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR(50)))
DECLARE 
    @version VARCHAR(30)= CAST(LEFT(@productver, CHARINDEX('.', @productver)-1) AS INT)
SELECT 
    'SQL Server '+CASE @version
                      WHEN 9
                          THEN '2005'
                      WHEN 10
                          THEN '2008'
                      WHEN 11
                          THEN '2012'
                      WHEN 12
                          THEN '2014'
                      WHEN 13
                          THEN '2016'
                      WHEN 14
                          THEN '2017'
                              ELSE 'Unknow Version'
                    END + ' ' + CAST(SERVERPROPERTY('edition') AS VARCHAR(50))          AS SQLServerEdition,
    @productver                                                                         AS ProductVersion, 
    SERVERPROPERTY('productlevel')                                                      AS ServicePack