This topic has not yet been rated - Rate this topic

@@VERSION (Transact-SQL)

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

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

Topic link icon Transact-SQL Syntax Conventions


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

Examples

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

SELECT @@VERSION AS 'SQL Server Version'

Reference

SERVERPROPERTY (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD