SQL Server/T-SQL Tutorial/System Settings/VERSION

Материал из SQL эксперт
Перейти к: навигация, поиск

This variable contains the complete version information for the current instance of SQL Server.

   <source lang="sql">

5> SELECT @@VERSION 6> GO



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)</source>


@@VERSION VersionInformation

   <source lang="sql">

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)</source>