Select @@version How to find SQL Server version installed on my Computer

Hi friends, One day I was planning to install SQL 2014 version in my laptop ,but i found that another version of SQL Server is already running in my laptop.So i decided to check what version of SQL Server is running on my Computer now using SQL Query.That investigation leads me to a beautiful SQL Query for finding SQL Server version –Select @@version

Now i will explain How to check the version and edition of Microsoft SQL Server on a machine using SQL query SELECT @@VERSION

select @@version as [Sql Version]
How to tell what SQL Server version you are running.How to determine the version, edition, and update level of SQL

When we execute the above SQL Query ,we will get result as shown in above image.I installed SQL Server 2008 R2 in my computer So result will be as given below

Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 (Build 9200: )

Hi,if you have any alternative solution to find SQL Server version and edition please let me know.

Leave a Reply

Your email address will not be published. Required fields are marked *