Skip Navigation Links
  

SQL Server Developer Center

Click to Rate and Give Feedback
Transact-SQL Reference
 @@VERSION
Transact-SQL Reference (SQL Server 2000)
@@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

© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker