Export (0) Print
Expand All
7 out of 10 rated this helpful - Rate this topic

@@VERSION (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions

@@VERSION

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.

SELECT @@VERSION AS 'SQL Server Version'

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.