version-transact-sql-configuration-functions.md

title	@@VERSION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	@@VERSION @@VERSION_TSQL
dev_langs	TSQL
helpviewer_keywords	@@VERSION function current SQL Server installation information versions [SQL Server], @@VERSION processors [SQL Server], types
ms.assetid	385ba80e-7c28-41a5-9cdb-5648f3785983
caps.latest.revision	40
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Version - Transact SQL Configuration Functions

[!INCLUDEtsql-appliesto-ss2008-all_md]

Returns system and build information for the current installation of [!INCLUDEssNoVersion].

Transact-SQL Syntax Conventions

Syntax

-- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
@@VERSION  

Return Types

nvarchar

Remarks

The @@VERSION results are presented as one nvarchar string. You can use the SERVERPROPERTY (Transact-SQL) function to retrieve the individual property values.

For [!INCLUDEssNoVersion], the following information is returned.

• [!INCLUDEssNoVersion] version

• Processor architecture

• [!INCLUDEssNoVersion] build date

• Copyright statement

• [!INCLUDEssNoVersion] edition

• Operating system version

For [!INCLUDEssSDSfull], the following information is returned.

• Edition- "Windows Azure SQL Database"

• Product level- "(CTP)" or "(RTM)"

• Product version

• Build date

• Copyright statement

Examples

A: Return the current version of [!INCLUDEssNoVersion]

The following example shows returning the version information for the current installation.

SELECT @@VERSION AS 'SQL Server Version';  

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

B. Return the current version of [!INCLUDEssDW]

SELECT @@VERSION AS 'SQL Server PDW Version';  

See Also

SERVERPROPERTY (Transact-SQL)