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]
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.