CODEWITHSUNDEEP
sqlsql-serverdatabaseversion
chandu
chandu

Reputation: 19

SQL server version query

How to check whether we have installed sql server full version or client version ?

Upvotes: 0

Views: 11499

Answers (6)

user12369723
user12369723

Reputation: 11

Inspired by Alexandru's answer. Provides all information required to build a version string such as:

Microsoft SQL Server 2014 Web Edition (64-bit) (SP3) (KB4022619) - 12.0.6024.0

select
'Microsoft' as Developer,
'SQL Server ' + case serverproperty('ProductMajorVersion')
    when '16' then '2022'
    when '15' then '2019'
    when '14' then '2017'
    when '13' then '2016'
    when '12' then '2014'
    when '11' then '2012'
    when '10' then '2008'
    when '9' then '2005'
    when '8' then '2000'
    else 'Unknown'
end as SqlVersion,
serverproperty('Edition') as Edition,
serverproperty('ProductLevel') as ProductLevel,
serverproperty('ProductUpdateReference') as ProductUpdateReference,
serverproperty('ProductVersion') as ProductVersion,
serverproperty('ServerName') as ServerName

Upvotes: 0

Super Kai - Kazuya Ito
Super Kai - Kazuya Ito

Reputation: 1

Try this to know your SQL Server Version:

SELECT @@VERSION

Upvotes: 0

Jafar Sadik
Jafar Sadik

Reputation: 113

In linux Terminal: $ sqlcmd -S localhost -U sa

Note: Here sa is the username, change it if your username is different.

Provide your password then enter your sql server. Write: 1> select @@VERSION 2> GO

The sql server version output

Upvotes: 0

Alexandru-Codrin Panaite
Alexandru-Codrin Panaite

Reputation: 734

I've created this query which it gonna return data like this: SQL Server 2016 Standard Edition (64-bit) 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

Upvotes: 0

Thiru
Thiru

Reputation: 74

You can use Select @@version

Or to get more data:

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

Upvotes: 2

Pintu Kawar
Pintu Kawar

Reputation: 2156

To get some more details like Edition, Service Pack.

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

Upvotes: 0

Related Questions