@@VERSION

Transact-SQL Reference

Transact-SQL Reference

@@VERSION

Returns the date, version, and processor type for the current installation of Microsoft® SQL Server™.

Syntax

@@VERSION

Return Types

nvarchar

Remarks

The information returned by @@VERSION is similar to the product name, version, platform, and file data returned by the xp_msver stored procedure, which provides more detailed information.

Examples

This example returns the date, version, and processor type for the current installation.

SELECT @@VERSION

See Also

Configuration Functions

xp_msver