@@VERSION: contains the complete version information for the current instance of SQL Server : Version « Transact SQL « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Transact SQL
3. Version

@@VERSION: contains the complete version information for the current instance of SQL Server

1> -- @@VERSION: contains the complete version information for the current instance of SQL Server.
2>
3> SELECT @@VERSION
4> 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)
1>
           
       

Related examples in the same category