What is SQL?            

SQL stands for Structure Query Language mostly we pronounced “see-quel”. We use sql language to communicate with the Relational Databases. Using SQL we can perform multiple operation on Relational Databases like Insert, Search, Update and delete a record form the table or relational databases. All DBMS (Database Management Systems) like MySQL Database, Sybase, MS SQL server and Oracle uses SQL for dealing with relational databases. All DBMS use same syntax for SQL.

► Play

Checking SQL Version

There lot of methods to find or show the SQL server version in operating systems (Windows, Linux etc.). We can use different commands from terminal to find SQL version and also we can find by writing a query and execute that query.

Find version through dpkg          

dpkg -l | grep -i mssql-server

ii mssql-server 14.0.3008.27-1

amd64 Microsoft SQL Server Relational Database Engine

Using SQL Queries

Simple query

The simplest query to find the SQL version

Select @@version

The output of this query is like given below

Microsoft SQL Server 2008 ( SP1 )  –  10.0.2531.0 ( X64 ) Mar 29 2009
10 : 11 : 52 Copyright ( c ) 1988-2008 Microsoft Corporation Express
Edition ( 64 bit ) on Windows NT 6.1 < X64 > ( Build 7600 : )

Advanced Query

We can find the SQL version details using this query.

SELECT

SERVERPROPERTY (‘ productversion ‘) as ‘Server Version’,

SERVERPROPERTY (‘ productlevel ‘) as ‘Server Level’,

SERVERPROPERTY (‘ edition ‘) as ‘Server Edition’,

SERVERPROPERTY (‘ buildclrversion ‘) as ‘Server Version’,

SERVERPROPERTY (‘ collation ‘) as ‘Default Collation’,

SERVERPROPERTY (‘ instancename ‘) as ‘Instance Name’,

SERVERPROPERTY (‘ lcid ‘) as ‘LC ID’,

SERVERPROPERTY (‘ servername ‘) as ‘Server Name’

That gives you an output something like this:
Server Version Server Level      Server Edition   Server Version
10.0.2531.0        SP1 Developer Edition (64-bit) v2.0.50727
Default Collation            Instance Name LC ID      Server Name
Latin1_General_CI_AS NULL                     1033      *********

Check SQL Version using GUI

  • Press Windows Key + S.
  • In the searching bar write the SQL server configuration Manager and then press enter key.
  • Press the SQL server services highlighted in the top left corner of the frame
  • Right-click SQL Server (PROFXENGAGEMENT) and click Properties.
  • Right click on SQL server and left click on the properties.
  • Select the advanced properties option.
  • Browse to Stock Keeping Unit Name and Version

Output like this

SQL Server 2008:
SQL Server 2008 Service Pack 4 (10.00.6000.29)
SQL Server 2008 Service Pack 3 (10.00.5500.00)
SQL Server 2008 Service Pack 2 (10.00.4000.00)
SQL Server 2008 Service Pack 1 (10.00.2531.00)
SQL Server 2008 RTM (10.00.1600.22)
SQL Server 2008 R2:

SQL Server 2008 R2 Service Pack 3 (10.50.6000.34)
SQL Server 2008 R2 Service Pack 2 (10.50.4000.0)
SQL Server 2008 R2 Service Pack 1 (10.50.2500.0)
SQL Server 2008 R2 RTM (10.50.1600.1)
SQL Server 2012:

SQL Server 2012 Service Pack 2 (11.0.5058.0)
SQL Server 2012 Service Pack 1 (11.00.3000.00)
SQL Server 2012 RTM (11.00.2100.60)
SQL Server 2014:

SQL Server 2014 Service Pack 1 (12.0.4100.1)
SQL Server 2014 RTM (12.0.2000.80)
SQL Server 2016:

SQL Server 2016 SP2 (13.0.5026.0 – April 2018)
SQL Server 2016 SP2 (13.0.5233.0 – November 2018)
SQL Server 2016 SP1 (13.0.4541.0 – November 2018)
SQL Server 2016 RTM (13.0.2216.0 – November 2017)

In order to check the version of SQL Server, simply enter the following query:

SELECT @@VERSION

The output should be something like this:

Microsoft SQL Server 2017 (RTM) – 14.0.1000.169 (X64)
Jun 28 2019 17:04:49
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 16299: )

How to Check SQL Server Version:

This article will help you to identify your Microsoft SQL Server database software version.

Method 1:

  • Log in the Windows Server system hosting your SQL server database.
  • Open Command Prompt
  • Run the following command

Server_name is your server name and instance_name is the name of the SQL instance.

  • execute
  • Press Enter key.
  • When the 2> prompt appears, type ‘go’ and Enter Again.
  • Output :

Method 2:

  • Open Microsoft SQL Server Management Studio.
  • Connect to your Database.
  • Right click on the instance name and select ‘Properties’.
  • The following window will open containing the version of the SQL Server.

How To Check MySQL Version

  1. From command line

            # mysql –version

  1. From mysql server command line

mysql> SELECT VERSION();

  1. From phpMyAdmin: Visit phpMyAdmin page of your host & on the right-hand side you’ll find all the details as below:

Send us a feedback0/500

Do you like this article?
Yes
No