Skip to content

version-transact-sql-configuration-functions.md

Latest commit

 

History

History
102 lines (72 loc) · 3.83 KB

version-transact-sql-configuration-functions.md

File metadata and controls

102 lines (72 loc) · 3.83 KB
description @@VERSION - Transact SQL Configuration Functions
title @@VERSION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/20/2018
ms.prod sql
ms.prod_service database-engine, sql-database, synapse-analytics, pdw
ms.reviewer
ms.technology t-sql
ms.topic 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
author LitKnd
ms.author kendralittle
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

@@VERSION - Transact SQL Configuration Functions

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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

Topic link icon Transact-SQL Syntax Conventions

Note

We are aware of an issue where the product version reported by @@VERSION is incorrect for Azure SQL Database.

The version of the SQL Server database engine run by Azure SQL Database is always ahead of the on-premises version of SQL Server, and includes the latest security fixes. This means that the patch level is always on par with or ahead of the on-premises version of SQL Server, and that the latest features available in SQL Server are available in Azure SQL Database.

To programmatically determine the engine edition, use SELECT SERVERPROPERTY('EngineEdition'). This query will return '5' for Azure SQL Database and '8' for Azure SQL Managed Instance.

We will update the documentation once this issue is resolved.

Syntax

@@VERSION

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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.

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

  • Edition- "Microsoft SQL Azure"

  • Product level- "(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)