@@VERSION VersionInformation : VERSION « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. VERSION
6> select @@VERSION VersionInformation
7> GO
VersionInformation

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
        Oct 14 2005 00:33:37
        Copyright (c) 1988-2005 Microsoft Corporation
        Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)


(1 rows affected)








26.42.VERSION
26.42.1.This variable contains the complete version information for the current instance of SQL Server.
26.42.2.@@VERSION VersionInformation