@@VERSION (Transact-SQL)

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

Topic link iconTransact-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)

Help and Information

Getting SQL Server 2005 Assistance