Export (0) Print
Expand All

@@VERSION (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see @@VERSION.

Returns edition, product level and version, build date, and copyright information for the current installation of Microsoft Azure SQL Database.

Syntax Conventions (Azure SQL Database)


@@VERSION

nvarchar

The @@VERSION results are presented as one nvarchar string, which includes the following information:

  • Edition- “Azure SQL Database”; followed by

  • Product level- “(CTP)” or “(RTM)”; followed by

  • Product version- “11.mm.bbbb.rr” ; followed by

  • Build date; followed by

  • Copyright statement

An example return value is as follows: “Azure SQL Database (RTM) - 11.25.9501.0 Aug 10 2011 13:04:51 Copyright (©) Microsoft Corporation”.

You can use the SERVERPROPERTY (Azure SQL Database) function to retrieve the individual property values.

Community Additions

ADD
Show:
© 2014 Microsoft