Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
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)