Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

@@VERSION (Transact-SQL)

SQL Server 2008

Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

Topic link iconTransact-SQL Syntax Conventions

Copy 

@@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.

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

Copy 
SELECT @@VERSION AS 'SQL Server Version'
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ