@@VERSION (Transact-SQL)

@@VERSION (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns system and build information for the current installation of SQL Server.

Topic link icon Transact-SQL Syntax Conventions

@@VERSION
-- Azure SQL Data Warehouse and Parallel Data Warehouse
@@VERSION

nvarchar

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

For SQL Server, the following information is returned.

  • SQL Server version

  • Processor architecture

  • SQL Server build date

  • Copyright statement

  • SQL Server edition

  • Operating system version

For Azure SQL Database, the following information is returned.

  • Edition- "Windows Azure SQL Database"

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

  • Product version

  • Build date

  • Copyright statement

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

SELECT @@VERSION AS 'SQL Server Version';

Community Additions

ADD
Show:
© 2016 Microsoft