Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

@@VERSION (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions



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.

The following example shows returning the version information for the current installation.

SELECT @@VERSION AS 'SQL Server Version'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft