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 information returned by @@VERSION is similar to the product name, version, platform, and file data that is returned by the xp_msver stored procedure; however, xp_msver provides more detailed information.
Examples
The following example shows returning the version information for the current installation.
SELECT @@VERSION AS 'SQL Server Version'
See Also
Reference
Configuration Functions (Transact-SQL)
xp_msver (Transact-SQL)
SERVERPROPERTY (Transact-SQL)