@@VERSION (Transact-SQL)
Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.
Transact-SQL Syntax Conventions
Składnia
@@VERSION
Return Types
nvarchar
Uwagi
The @@VERSION results are presented as one nvarchar string. You can use the SERVERPROPERTY (Transact-SQL) function to retrieve the individual property values.
Examples
The following example shows returning the version information for the current installation.
SELECT @@VERSION AS 'SQL Server Version'