Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
@@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'