How to Find Out SQL Server Version - @@VERSION Function

Connect to a Microsoft SQL Server database, and execute @@VERSION function to find out the version, processor architecture, build date, and operating system for the current installation of SQL Server.

   -- Define the SQL Server version
   SELECT @@VERSION;

The query result on SQL Server 2012

SQL Server 2008 R2:

@@VERSION function returns a single string, and you can also use SERVERPROPERTY function to retrieve the individual values:

   -- Get SQL Server edition
   SELECT SERVERPROPERTY('Edition');

The query result:

   -- Get product version (Major.Minor.Build.Revision)
   SELECT SERVERPROPERTY('ProductVersion');

The query result on SQL Server 2012:

SQL Server 2008 R2:

Last Update: Microsoft SQL Server 2012

• SQL Server Articles and Reference
• How to Get a List of Instances on Local System

SQL Server 2012 Books Online

• @@VERSION (Transact-SQL)
• SERVERPROPERTY (Transact-SQL)
• How to Determine the Version and Edition of SQL Server and its Components